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.
Hi Anonymous
Can you provide a data sample?
Many Thanks
Mariusz
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.
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.