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! 😀
Community ChampionIF I mocked this up in a PBIX, can you confirm that I did it correctly? Your measure is going to calculate the SUM for # rows always the way it is written. See PBIX below sig. It is odd that the slicer does not seem to be impacting the card visual though.
Post ProdigyHi, It is not working for slicer one 😞
- IF
- lkalawski
Resident Rockstar
IF ,
Please use this file: https://gofile.io/d/4Szfws
You had an issue in the measure code.
_______________
If I helped, please accept the solution and give kudos! 😀
- IF
If A (07.2020) is selected I want to see value:12 . If C1 is selected, I want to see value 21.