Forum Discussion
Post ProdigyDefault selection with or without a slicer
Hi IF ,
Please try this measure:
Plan Working = VAR _slider1 = SELECTEDVALUE('Table'[Slider1]) RETURN IF(NOT(HASONEVALUE('Table'[Slider1])) && NOT(HASONEVALUE('Table'[Slider2])), CALCULATE(Sum('Table'[Value]), FILTER('Table', 'Table'[Slider1] = "#" && 'Table'[Slider2] = "#")), [Plan Working3] )
_______________
If I helped, please accept the solution and give kudos! 😀
Post ProdigyHi,
To make it clear, it will be easy to run the current measure without column "MainFilter". As you can see from the current measure you can select date; for example; 07.2020. If I select A, result is 12. Similarly the result is 14 for B, 21 for C1, 23 for C2, 32 for D1 and 34 for D2. Until it works.
What I want if either slider1 or slider2 is not selected, I want to see the value 66 as I explained at the previous post.
I hope it is clear.
Thanks in advance!
Post ProdigyHi,
Here is another link. https://gofile.io/d/cuPNYz
I tried in two ways. The first file screen shots. If Slider1 or Slider2 is not selected, I want to see 66 value in a measure (for month 07.2020).
I tried with another way at night. The link has second file.
I saw a similar example with another project. It was not in a similar way, but mine doesn't work.
If there is a better way of uploading the files, I can do it in that way. I think it is quite easy if you open the files.
All the best,
- lkalawski
Resident Rockstar
Hi IF ,
Please try this measure:
Plan Working = VAR _slider1 = SELECTEDVALUE('Table'[Slider1]) RETURN IF(NOT(HASONEVALUE('Table'[Slider1])) && NOT(HASONEVALUE('Table'[Slider2])), CALCULATE(Sum('Table'[Value]), FILTER('Table', 'Table'[Slider1] = "#" && 'Table'[Slider2] = "#")), [Plan Working3] )
_______________
If I helped, please accept the solution and give kudos! 😀