Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Count with Multiple Conditions and Multiple Column Referenced

Hello,   I'm currently stumped on a DAX formula, which I need to count the number of entries in a column (let's call it Rule). I need it to be filtered for the following conditions which are conta...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

 

Does this measure work?

=CALCULATE(COUNT('Table1'[Rule]),'Table1'[Status] = "Active",'Table1'[Condition] = "Performing As Expected"),FILTER('Table2','Table2'[PercentageBin] = "81-90%" || 'Table2'[PercentageBin] = "91-100%"))