How to count values in a column

[android1]

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))

[Greg_Deckler · Accepted solution]

So, just create a calculated column like:

79 = IF([% Worked]<=79,1,0)

Then you can just do a COUNT aggregation on [79].

[v-caliao-msft · Accepted solution]

@android1

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

[Greg_Deckler]

Try:

CALCULATE(COUNTROWS(AVS),AVS[% Worked]<=79)

[android1]

Still 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.

[android1]

[Greg_Deckler · Accepted solution]

So, just create a calculated column like:

79 = IF([% Worked]<=79,1,0)

Then you can just do a COUNT aggregation on [79].

[android1]

Still getting the exact same results using a column

[android1]

My measure [% Worked] is formatted as percentage. Could this be causing the unexpected results?