Forum Discussion
Conditional value in Filtering context
Hi sebouier ,
AnkitaaMishra Thanks for your reply!
And sebouier , please try this way:
First use this DAX to create a new table for slicer:Slicer = VALUES('Table'[Cat])Note: without any relationship!
Then use this DAX to create a measure:
Measure = VAR _Cat = VALUES(Slicer[Cat]) VAR _Name = MAX('Table'[Name]) RETURN IF( CALCULATE( COUNTROWS( FILTER( 'Table', 'Table'[Name] = _Name && 'Table'[Cat] IN _Cat ) ), ALLSELECTED('Table') ) > 0, 1, 0 )Set it up as shown in the following figure:
Then use this DAX to create another measure:
Flag = IF( MAX('Table'[Cat]) IN VALUES(Slicer[Cat]), 1, 0 )And put this measure into the table visual:
The final output is as below:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super Userhi sebouier ,
If my understanding is clear and below is the expected output for your problem statement :
Then please follow below steps :
- Create a summarize table :
- Create a many to many relationship with your originaltable and summarized table based on NAME column
- Use the slicer for CAT from summarize table
- create the table visual by using columns from your originaltable (All the columns in table visual are coming from OriginalTable)
If this approach works for you, please select it as solution.
Thanks,
Ankita
Thanks for your quick help AnkitaaMishra .
Your approach is very elegant and smart.
My approach was slightly different because I duplicated the Originaltable into Copytable. And I created a similar relation as yours: Originaltable.Name -> Copytable.Name
Then I displayed on a visual table the fields from Copytable.
But my real struggle is to be able to identify the filtered row in Originaltable.
How would you proceed to add a column as a "filtered row flag"?
Result expected :
| Id | Name | Cat | filtered row flag |
| 2 | Allan | b | 1 |
| 3 | Allan | c | 0 |
| 4 | Jason | e | 0 |
| 5 | Jason | f | 1 |