How to count things in a column based on condition - Summarized measure

DAX DAX Calculations
1

I have following:

Categoty Available %
A 75%
B 80%
C 95%
D 100%
E 101%
F 112%
G 50%
H 100.50%
I 0%

Here Available % is a measure. My problem is how to count “number of categories” having “Available %” >= 100%?
in the above example answer would be 4.
I feel that this is simple yet struggling. Please help. I could provide file if needed

2

Hi @pshetty,

Give something like this a go.

number of categories = 
COUNTROWS(
    FILTER(
        ADDCOLUMNS(
            VALUES( 'Sample'[Categoty] ),
            "Available PCT", [Available %] // enter your measure here
        ),  [Available PCT] >1
    )
)
1 Like
3

Okay. I will try that and let you know. Thanks

4

This worked. Thank you so much. I don’t use these kid of Dax much and keep forgetting methods.