How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

[Anonymous]

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

[Mariusz]

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.

[Anonymous]

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.

[Anonymous]

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.

[Mariusz]

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.