Forum Discussion
Duplicate filters on same page
- 6 years ago
Hi , rvcedd
According to your description, you can try to follow these steps :
1)Create two calculated table :
slicer = DISTINCT(Table2[CategoryFullName])slicer2 = DISTINCT(Table2[CategoryFullName])2)Create two measures to display the average of Category Value:
MeasureAvg1 = VAR SLICER1 = VALUES ( slicer[CategoryFullName] ) RETURN CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN SLICER1 ) )MeasureAvg2 = VAR SLICER2 = VALUES ( 'slicer 2'[CategoryFullName] ) RETURN CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN SLICER2 ) )3)Create a new measure to replace the value in the visual:
Measure= VAR un = UNION ( VALUES ( slicer[CategoryFullName] ), VALUES ( 'slicer 2'[CategoryFullName] ) ) RETURN IF ( ISFILTERED ( slicer[CategoryFullName] ) && ISFILTERED ( 'slicer 2'[CategoryFullName] ), CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN un ) ), BLANK () )Here is a sample:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , rvcedd
According to your description, you can try to follow these steps :
1)Create two calculated table :
slicer = DISTINCT(Table2[CategoryFullName])slicer2 = DISTINCT(Table2[CategoryFullName])
2)Create two measures to display the average of Category Value:
MeasureAvg1 =
VAR SLICER1 =
VALUES ( slicer[CategoryFullName] )
RETURN
CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN SLICER1 ) )MeasureAvg2 =
VAR SLICER2 =
VALUES ( 'slicer 2'[CategoryFullName] )
RETURN
CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN SLICER2 ) )
3)Create a new measure to replace the value in the visual:
Measure=
VAR un =
UNION (
VALUES ( slicer[CategoryFullName] ),
VALUES ( 'slicer 2'[CategoryFullName] )
)
RETURN
IF (
ISFILTERED ( slicer[CategoryFullName] )
&& ISFILTERED ( 'slicer 2'[CategoryFullName] ),
CALCULATE ( [MeasureAvg], FILTER ( Table1, Table1[Column] IN un ) ),
BLANK ()
)
Here is a sample:
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Many thanks for your reply this is really useful.