Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to use DAX SelectedMeasure and ISSELECTEDMEASURE Functions

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 tha...
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

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.
Mariusz Repczynski

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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.