Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi there,
I have a measure that returns either 'yes' or 'no' value. Now I want to apply that meausre on a table and count how many rows return 'yes'value. I am not sure how to count the yes value that comes out from the measure. Any help would be really appreciated.
Solved! Go to Solution.
You can try this approach, which will count the number of values in a column return yes for your measure.
Yes Count = COUNTROWS(FILTER(VALUES(Table[Column]), [YourMeasure] = "yes"))
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can try this approach, which will count the number of values in a column return yes for your measure.
Yes Count = COUNTROWS(FILTER(VALUES(Table[Column]), [YourMeasure] = "yes"))
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |