Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
@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.
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 🙂
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.
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!!
User | Count |
---|---|
73 | |
73 | |
39 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
51 | |
43 | |
42 |