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.
corporate here is more detail on what-if parameter
Thank you parry2k , but unfortunately this is not what I need, or I didn't understand how to use it.
From what I see, the what-if parameter must be created manually; I want a filter that automatically adjusts it's maximum and minimum values every time I change the filters on the page and the Production values in the Power BI table change.
Let me know if I haven't well explained my problem.
Thank you!