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

4 Replies

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