Forum Discussion
SELECTEDVALUE with Slicer Selection
- 6 years ago
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! 😀
Hi, It is not working for slicer one 😞
- IF6 years ago
Post Prodigy
- lkalawski6 years ago
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! 😀- IF6 years ago
Post Prodigy
Hi,
I checked the file but it gives wrong number with A value. It should be 12 for 07.2020 but it shows 56. It sums all but, it is not helpful.
All the best
- IF6 years ago
Post Prodigy
If A (07.2020) is selected I want to see value:12 . If C1 is selected, I want to see value 21.