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!

mark77's avatar
mark77
Helper I
5 years ago

Hi! I'm dieing to see what the BPIX file does, but it appears to have an issue. I cannot open it with x64 December2020 version of powerbi. Do I need to install additional components ?

I tried reinstalling PBI