Forum Discussion
Filter from measure in a table
- 6 years ago
Hi, corporate
Based on your description, I created data to reproduce your scenario.Table:
Test (a calculated table):
Test = GENERATESERIES(0,10000,1)You may create three measures as below.
Slicer Control = var t = SUMMARIZE( 'Table', 'Table'[Region], 'Table'[Province], "MeasureValue",CALCULATE([Measure]) ) return IF( COUNTROWS( FILTER( t, [MeasureValue]=SELECTEDVALUE(Test[Value]) ) )>0, 1, -1 ) Table Control = IF([Measure] in DISTINCT('Test'[Value]),1,-1) Measure = SUM('Table'[Production])Then you need to put 'Slicer Control' in the visual level filter of 'Value' slicer and put 'Table Control' in the visual level filter of table visual.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, corporate
Based on your description, I created data to reproduce your scenario.
Table:
Test (a calculated table):
Test = GENERATESERIES(0,10000,1)
You may create three measures as below.
Slicer Control =
var t =
SUMMARIZE(
'Table',
'Table'[Region],
'Table'[Province],
"MeasureValue",CALCULATE([Measure])
)
return IF(
COUNTROWS(
FILTER(
t,
[MeasureValue]=SELECTEDVALUE(Test[Value])
)
)>0,
1,
-1
)
Table Control =
IF([Measure] in DISTINCT('Test'[Value]),1,-1)
Measure = SUM('Table'[Production])
Then you need to put 'Slicer Control' in the visual level filter of 'Value' slicer and put 'Table Control' in the visual level filter of table visual.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much v-alq-msft !