Forum Discussion

mark77's avatar
mark77
Helper I
5 years ago

Conditional Show Values in crosstable

My users would like a filter with (say) 20 measures. In this filterbox they wish to select which values / expressions shuold be calculated. ( Forecast, realization, profit, costprice etc). Making a ...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi mark77 ,

 

First create a measure table as below:

 

Then create a measure as below:

Measure = 
SWITCH(
    SELECTEDVALUE('measure table'[Column1]),
    "measure 1",[Measure 1],
    "measure 2",[Measure 2])

And you will see:

 

For the related sample .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

edhans's avatar
edhans
Community Champion
5 years ago

v-kelly-msft can you please ensure you and your team are using publically released versions of Power BI? I have the latest from the app store and I cannot open this file.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi edhans ,

     

    Thanks for your notification,I have downgraded the desktop version,check my last reply.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!