Forum Discussion

TAlvarez's avatar
TAlvarez
Frequent Visitor
10 years ago

Dynamic Column based on aggregated measure

Hello all,   I am trying to create a dynamic dimension based on a slicer, to do this I could use the switch function to populate a column based on a measurement such as max or min from a detached t...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

TAlvarez

 

We should be able to pass the measurement result to a column in a different table. Please refer to following simple sample.

If you still have any question, please feel free to ask.

 

Regards,

 

  • TAlvarez's avatar
    TAlvarez
    Frequent Visitor
    10 years ago

    Thank you for your suggestion, I have tried this before and it only gives you the min of the all the column values, no matter the slicers or filters you choose.

    • v-sihou-msft's avatar
      v-sihou-msft
      Microsoft Employee
      10 years ago

      TAlvarez

       

      Please try to create two calculated measures as below. ALLSELECTED looks like a function that is able to understand what the user selected.

       

      MinNum = MIN ( Table1[TestNum] )

      TestMeasure = CALCULATE ( [MinNum], ALLSELECTED ( Table1[TestNum] ) )

       

      Regards,

      • TAlvarez's avatar
        TAlvarez
        Frequent Visitor
        10 years ago

        HI Simon,

         

        I have also tried this before but it won't work either.  Remember I am trying to make a dynamic dimension which means I need a column to change value when a measurement does.  If you input the calculate column value into a column it will alwyas read the max or min value of the total dataset, even if you filter or set any calculation filters.

         

        What Power BI here really needs is a global variable that can be interchanged among tables and measurements.