Forum Discussion
SELECTEDVALUE does not return selected value when using Calculation group
I have a calculation group created for Time Intelligence with 3 items MTD, YTD and Full Year. When I use the calculation group as a slicer with "Full Year" selected, the Selected Month measure does not show the selected month. How can I make it ignore the Calculation group slicer selection and always show the selected month?
Link to sample file
8 Replies
Hello VickyDev18 ,
Hope you are doing well.
Could you please share the sample file if possible?Hi KeyurPatel14 .. I did put a link to the file in my post above. Did it not work?
Here's the link.It is showing that the file has been deleted!!
You can consider changing the filter interactions. Click the slicer --> Format (top bar) --> Edit Interactions. sometimes this may be helpful so that you don't have to worry about changing your Dax around 🙂
Yes, that's an option but I was looking to see if there was a way it would work at a measure level using DAX so I don't have to keep fiddling with Edit interactions each time :). I thought using ALL or REMOVEFILTERS would do the trick but for whatever reason it isn't working.
VickyDev18 Have you been able to find a solution to this? I'm dealing with the same issue where adding calculation goups to the PBI page makes anything that has SELECTEDVALUE() used in DAX to not function and return blank, similar to what you mentioned, using All and REMOVEFILTERS didn't help, looking at the query from performance analyzer, the calc group completely ignores the slicer selection that needs to be acknowledged in multiple visuals.
Hi VickyDev18,
did you find a solution for this issue?
I have exactly the same issue but I need to use the selectedvalue in a DAX measure so I must get the real month selected.I noticed that when the Period selected is MTD the selected value return the correct value so I tried to force the calculation in the context related Period='MTD' but also in that case didn't work
regards
