Forum Discussion
Post PatronHow to count values in a column
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))
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
8 Replies
- Greg_Deckler
Community Champion
Try:
CALCULATE(COUNTROWS(AVS),AVS[% Worked]<=79)
android1Still not getting correct results ->
- Greg_Deckler
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.
v-caliao-msftMicrosoft Employee
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