Help with Measure

[Kieran-q_20]

Hi guys, 

I am trying to create a measure which can count how many values in another column below a specific number. Any help would be greately appreciaated, Thank you 

[v-xinruzhu-msft]

Hi @Kieran-q_20 

You can use countax（） function

e.g ：

measure = COUNTAX（FILTER（ALL（'TABLE 3'），[aaa]=SELECTEDVALUE（'Table 3'[aaa]）），[aaa]）

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lukiz84 · Accepted solution]

hi,

YourMeasure =
    CALCULATE(
        COUNT(YourTable[YourColumn]),
        YourTable[YourColumm] < 123
    )