Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a calculated column % Worked = (AVS[Real Act Min]/AVS[scheduledMinutes]). I want to count the amount of times
the value in % Worked is <=79. Thought this should work but it's not -> 79 = COUNTROWS(FILTER(AVS,[% Worked]<=79))
Solved! Go to Solution.
So, just create a calculated column like:
79 = IF([% Worked]<=79,1,0)
Then you can just do a COUNT aggregation on [79].
The value is the actual data, regardless of the date format, change the 79 to 0.79, then if should behave as expected
Regards,
Charlie Liao
The value is the actual data, regardless of the date format, change the 79 to 0.79, then if should behave as expected
Regards,
Charlie Liao
Try:
CALCULATE(COUNTROWS(AVS),AVS[% Worked]<=79)
Still not getting correct results ->
Oh, >slaps self in forehead<, I understand what you are going for now, (I think). Can you post some sample data and your expected results? That way I can be sure I answer the correct problem.
So, just create a calculated column like:
79 = IF([% Worked]<=79,1,0)
Then you can just do a COUNT aggregation on [79].
Still getting the exact same results using a column
My measure [% Worked] is formatted as percentage. Could this be causing the unexpected results?
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |