Count row average

[Mo_mo]

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

[ibarrau]

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,

[LivioLanzo]

Could you post your dataset along with expected results? @Mo_mo