Forum Discussion
tjd
Impactful Individual
Impactful IndividualFilter/Hide Matrix row If Column Value Has One or More Zero
DAX experts - I have a matrix visual consisting of Users (rows - from Dim-Users) who respond in various categories (columns which come from a filtered subset of Fact-Elements[CatName], Cat A, Cat B, ...
Solved. I created the following measures:
1. # Categories = DISTINCTCOUNT('FACT-ELEMENTS'[CatName]) - calculates number of categories each User has a value > 0.
2. # Categories (Max) = CALCULATE(DISTINCTCOUNT('FACT-ELEMENTS'[CatName]), ALLSELECTED('USERNAMES'[User_ID])) - calculates the maximum number of categories across all users, i.e., the maximum number of categories I could have if all had a value >03. # Categories (Show Row) = IF([# Categories]=[# Categories (Max)], 1,0) - used to filter the matrix visual. If 1, user has at least a value >0 in each category and should be shown. Anything else is suppressed.
amitchandak
Super User
Super UserCan you share sample data and sample output.
Appreciate your Kudos.Mark me with @
Ok then first convert that cat A into int.
Add that cat A to visual level filter and set it as greater than 0.
If cat a is column then simplelu unselect 0 from visual level filter for cat A
If measure convert it it int and add to visual level filter.
Thanks
Pravin
Add that cat A to visual level filter and set it as greater than 0.
If cat a is column then simplelu unselect 0 from visual level filter for cat A
If measure convert it it int and add to visual level filter.
Thanks
Pravin