Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
VickyDev18
Advocate II
Advocate II

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

VickyDev18_0-1715688222201.png

 

8 REPLIES 8
MarioCoppola
Frequent Visitor

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

S_PBI
Regular Visitor

@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.

ExcelMonke
Super User
Super User

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 🙂 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.  

KeyurPatel14
Responsive Resident
Responsive Resident

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!!

Please try this link

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.