Forum Discussion
Post ProdigySELECTEDVALUE with Slicer Selection
Hi IF
Ok, I didn't understand you well last time.
You have two solutions:
1. Create one additional Slider column based on slider1 and slider2. (If slider1 = #, take slider2, otherwise slider1).
Add a new column as a slider and use it for filtering.2. Create a measure:
ValueMeasure = VAR _slider1 = SELECTEDVALUE('Table'[Slider1]) RETURN IF(ISFILTERED('Table'[Slider1]), CALCULATE(Sum('Table'[Value]), All('Table'[Slider2])), CALCULATE(Sum('Table'[Value]), FILTER('Table', 'Table'[Slider1] = "#")) )
_______________
If I helped, please accept the solution and give kudos! 😀
Resident RockstarHi IF
Why do you use the condition 'Table' [Slider1] = "#" in the measure?
When using such a condition, you cannot use Slicer1 because the measure will always calculate for "#".
If you want to dynamically change slicers and show the total, you just need to create a measure SUM ('Table' [Value]) and the values will change dynamically.
Examples:
If you want to include the date as well as a filter, add another slicer or add condition to the measure.
_______________
If I helped, please accept the solution and give kudos! 😀
IFHi,
If I delete the part: Table'[Slider1]="#" then, I don't get result for other slicer.
All the best