Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?