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.
Hello, I would like to know the number of rows where availability is not greater than 50 % For example :
Paris | 75% |
London | 0% |
NY | 90% |
So, I would like get 1, because I have 1 row smaller than 50%
The issue is that my availability is measure and not a column. I am using measure because I need to get DateTime in order to use slicer so I can't group in query. Average = AVERAGE(ResponseTime_Detail[Availability]) Do you have some ideas ? Thanks in advance
Hi. Can you be more specific?
If you are just trying to show a table with those fields. Add City and the column of the average. Then go to "Visual Filters" on your right and set it to lower than 50 or 0.5 (dependes on how are you seting the average).
If you are trying to have a Label with that informatión, in this case 1, you have to create a measure like this:
COUNTROWS (
FILTER (
ADDCOLUMNS (
SUMMARIZE ( Table, Table[City] ),
"average_name", AVERAGE ( Table[value] )
),
[average_name] > 0.5
)
)
Regards,
Happy to help!
Could you post your dataset along with expected results? @Mo_mo
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
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 |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |