Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically changing the values based dimen

I was going through this post https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027   I need to achieve a similar kind of funct...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi  Anonymous ,

I can't view the sample data. Please try to share it via DropBox.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Try this link.

This is dropbox hope it helps.

 

Thanks,

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    6 years ago

    Hi Anonymous ,

    I created a sample to try. 

    • Create a disconnect table to as a slicer.

    • Create a measure.
    Measure = 
var sel = SELECTEDVALUE('Table'[Product details])
return
SWITCH(TRUE(),sel = "P01",MAX(Sheet1[P0_L01]),sel = "P02",MAX(Sheet1[P0_L02]),1)

     As you seen, it will work fine when other columns show all the data. if we want to show total values of other columns, the measure will just show the max value. 

     

    I attach the sample. If you need to get it by DAX, I think you could choose to show all the data. If you could unpivot table, it might work more perfectly.

     

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello Xue Ding,

       

      Thanks for the reply but it is not aggregating the measures based on dimension but displaying MAX() based on the measure.

      Also, as mentioned previously I can not unpivot the columns because I have 15 levels of Hierarchy with data in GB's. I tried doing it but measure values are getting impacted in a whole report.

      How can we do this with DAX? could you help with it? as that will be the last option left

       

      Thanks,

      Zeenat

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        Hi Anonymous ,

        Sorry for I can't implement it perfectly with DAX. That answer is what I tried. It does have a flaw when show aggregating. After discussing with others, I think there may not be a way to fully meet your requirements.

         

        Best Regards,

        Xue Ding

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.