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 Kelly. Sorry for the delay. Had some eye troubles last week, so couldn;t really read any screens 😛

 

Just tried your sollution, and it does not quite do what I want.

I made a crosstable with "name" "measure1" and "measure 2"

 

The fields "measure1" and "measure2" remain visible, despite what I choose in filter "column 1" where you prodvided the filter:

 

Measure =
SWITCH(
SELECTEDVALUE('measure table'[Column1]),
"measure 1",[Measure 1],
"measure 2",[Measure 2])
 
The idea is to be able to select which measures to show

 

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

    Hi  mark77 ,

     

    Sorry for the late reply.

    Could you pls provide some sample data with expected output for test?

     

    Best Regards,
    Kelly

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

    • mark77's avatar
      mark77
      Helper I
      5 years ago

      Hi! Please have a look at this included file.

      Download PBIX from WeTransfer 

      I tweaked your file to more show what I desire.