Log In
Register
Home
October 28, 2021
Offline
Hi,
I attempted to create a DAX Formula to get the average for "no" and "yes" string; however, I received an error. This is the error: The function average takes an argument that evaluates to numbers or data and cannot work with values of type String. Our section supervisors review patients' records to ensure clerks have verified a patient's demographic by indicating "no" or "yes". I want to great a measure to get the average of "no" and "yes". I attach an example of the workbook. Please provide insight how to resolve issue.
See Answer
Moderators
January 31, 2022
Offline
Please clarify which averages you expect to see if you were to calculate them manually.
October 28, 2021
Offline
Sorry for the delay. Both for "no" and "yes" replies.
Moderators
January 31, 2022
Offline
What I meant is that you need to explain how you would calculate such an average.
October 28, 2021
Offline
Riny, hi, I'm back. It has been tasking to close out the fiscal year 2024 and start a new fiscal year for 2025 (October 1). My understanding Excel does not have a built-in function to calculate an average based on text (yes or no). If a numerical value was assigned, yes=1 and no=2, would this be a solution?
Moderators
January 31, 2022
Offline
Maybe, but I still don't understand. If 'Yes' would become 1 and 'No' would be 2, 3 yes and 2 no would average to (1+1+1+2+2) / 5 = 1.4. But does that mean?
Wouldn't you want to calculate the percentage number of Yes and No of the total number of indications? I've added some DAX measures that calculate such percentages. See attached. If this is not what you want, please explain what 'average' (in numbers) you expect to see in the pivot table.
Trusted Members
October 17, 2018
Offline
Hi, excuse my butting in 🙂
I'm not that proficient in Pivot Tables or DAX functions, but I like to play with formula's next to VBA.
This is my formula idea,
Answers Post
1 Guest(s)
