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! 😀
Post ProdigyHi,
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
Resident RockstarHi 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! 😀
- IF
Hi,
Thanks a lot. The second way works for me. I already accepted the solution. ps. The only problems is that if I select two from slicer2, I would like to get either total or n/a, etc. 🙂
All the best