Forum Discussion

ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

Count if with existing measure

Hello   I've had almost a year-long break from Power BI  and I've tried to look for the answer on the forum but without any luck. I would appreciate your help.   I am trying to recreate COUNT IF ...
Need Help
ewuchatka's avatar
ewuchatka
Icon for Helper II rankHelper II
8 years ago

Zubair_Muhammad

 

Thank you that's a great step towards what I need, it helps me calculate a total number of Weeks.

 

How can I amend the formula to get to number of weeks where AUP is below 1.10  i.e.  [AUP]<=1.10?

 

Thanks

 

Ewa

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

ewuchatka

 

Try with this

 

Measure =
COUNTX (
    FILTER ( ALLSELECTED ( TableName[Week_Column] ), [AUP Measure] < 1.1 ),
    1
)