topic Re: How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions in DAX Commands and Tips

How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

Anonymous — Fri, 02 Aug 2019 05:29:45 GMT

Hi PBI,

I have a requirement to change the calculations on a Table like (YTD/ QTD/MTD) based on Selections on a Filter. I came across this DAX function SELECTEDMEASURE which would be used for that in this below Article.

https://www.sqlbi.com/articles/introducing-calculation-groups/

I have currently imported all the Data into my Power BI Model and have not used an Analysis Services Instance connections for Data. I would like to understand how I could create a Calculated Item just as Shown in the above link so that I could make calculations dynamic based on the Selection made on a Slicer.

Thanks in Advance

Re: How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

Mariusz — Fri, 02 Aug 2019 07:21:13 GMT

Hi Anonymous

I don't think CALCULATED GROUPS are available in Power BI just yet.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

Re: How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

Anonymous — Fri, 02 Aug 2019 07:31:00 GMT

Is there Any other Workaround that I could use for this Requirement. Basically, what is needed is that I require to have a Filter where I specify what the Calculation is from which The Table Measures should throw the values based on the Selected Calculation.

Re: How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

Mariusz — Fri, 02 Aug 2019 08:00:40 GMT

Hi Anonymous

Sorry not sure what you want to achieve, but check out the below link to a blog post, maybe that is what you need.

https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

Re: How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

Anonymous — Tue, 17 Sep 2019 23:20:11 GMT

The blog that Mariusz is very useful if you plan on using a slicer. The other option is to use 3 buttons that mimic the appearance of slicer. create a single visualization for each, layer them, then use the button to go between them based on the selected button. Use the show hid in the selection pane to toggle.