Dax CountIf Equivalent

[iluvfnky]

Hi, I'm relatively new to Dax and want to count how many of my stores achieved their weekly budget. I have created a calculated column and basically want a counted total of 100% or greater, but I'm struggling to get the answer.

Can anyone help. Thanks

 

[Kazlik]

You could use COUNTA and make a measure like this.

CALCULATE(COUNTA(Sheet1[StoreName]),FILTER(Sheet1,Sheet1[calculated column] > 1))

 

[iluvfnky]

Thanks Kazlik, works a treat. I'm very grateful for your help.

 

[Matt Allington]

You should not use a calculated column for this. Power Pivot is not a spreadsheet, and hence it is optimised to work in a different way. If you don't already have this book, you should buy it and learn the correct way to do it.

DAX Formulas for PowerPivot – by Rob Collie « PowerPivotPro