Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have slicer (with values Churn1,Churn7,Churn28 and No Churn),
Selecting churn7 on slicer would filter the below table for Churn='Churn7' or Churn='Churn1' ,similarly on selecting churn28, filter would be Churn='Churn1' or Churn='Churn7' or Churn='Churn28' .
Dataset
TPID Churn
1 | Churn1 |
2 | Churn7 |
3 | Churn1 |
4 | Churn28 |
5 | Churn7 |
6 | No Churn |
Solved! Go to Solution.
Hi @atul9063,
There are some workarounds. But you should think again first. Because it's confusion. Please download the demo from the attachment.
1. Add an ID column to the slicer table.
2. Don't establish any relationship.
3. Create a measure.
Measure = VAR slicer = SELECTEDVALUE ( Table1[CHURNAME] ) VAR selected = CALCULATETABLE ( VALUES ( Table1[CHURNAME] ), FILTER ( ALL ( Table1 ), 'Table1'[ID] <= MIN ( 'Table1'[ID] ) && Table1[ID] > 0 ) ) RETURN IF ( slicer = BLANK (), 1, IF ( MIN ( Table2[Churn] ) IN selected, 1, BLANK () ) )
Best Regards,
Hi @atul9063,
There are some workarounds. But you should think again first. Because it's confusion. Please download the demo from the attachment.
1. Add an ID column to the slicer table.
2. Don't establish any relationship.
3. Create a measure.
Measure = VAR slicer = SELECTEDVALUE ( Table1[CHURNAME] ) VAR selected = CALCULATETABLE ( VALUES ( Table1[CHURNAME] ), FILTER ( ALL ( Table1 ), 'Table1'[ID] <= MIN ( 'Table1'[ID] ) && Table1[ID] > 0 ) ) RETURN IF ( slicer = BLANK (), 1, IF ( MIN ( Table2[Churn] ) IN selected, 1, BLANK () ) )
Best Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |