Forum Discussion

mark77's avatar
mark77
Icon for Helper I rankHelper 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
Icon for Community Support rankCommunity 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
    Icon for Helper I rankHelper 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

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity 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
      Icon for Community Support rankCommunity 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!

  • mark77's avatar
    mark77
    Icon for Helper I rankHelper 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
      Icon for Community Support rankCommunity 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
        Icon for Helper I rankHelper 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.