Forum Discussion
Count non-blanks in Matrix
Hi all! I've got this matrix based on Employees. Each employee can be in charge of multiple businesses, and each business has it's own Risk-level. Notice that Person B has a blank cell...
Hi Anonymous
You can use the below Dax Expression.
Risk m = IF( ISFILTERED(YourTable[Business]), MAX(YourTable[Risk]), DISTINCTCOUNTNOBLANK(YourTable[Risk]))
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Employee, Business, Risk
Person A, Business X, High
Person A, Business Y, Low
Person B, Business W,,
Person B, Business O, Medium
Comma error, fixed.
Mariusz
Community Champion
Community ChampionHi Anonymous
You can use the below Dax Expression.
Risk m = IF( ISFILTERED(YourTable[Business]), MAX(YourTable[Risk]), DISTINCTCOUNTNOBLANK(YourTable[Risk]))
Regards,
Mariusz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.