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

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

Try creating a measure like this:

 

Measure = Calculate(Countrows([table]);[AUP]>1)

 

Assuming you have one row per week, place this in a table with a row for each year you should get the amount of weeks > 1.

 

 / Johannes