Dynamic Column based on aggregated measure

Question

Hello all,&nbsp;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 table. &nbsp;However when I try to do this I have not found a way to make Power BI pass the measurement result to a column in a different table. &nbsp;With other applications you are able to do this with variables but I can't replicate similar functionality in Power BI.

v-sihou-msft · Answer

TAlvarez
&nbsp;
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.
&nbsp;
Regards,
&nbsp;

talvarez · Answer

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&nbsp;you choose.

v-sihou-msft · Answer

TAlvarez
&nbsp;
Please try to create two calculated measures as below. ALLSELECTED looks like a function that is able to understand what the user selected.
&nbsp;
MinNum = MIN ( Table1[TestNum] )
TestMeasure = CALCULATE ( [MinNum], ALLSELECTED ( Table1[TestNum] ) )
&nbsp;

Regards,

talvarez · Answer

HI Simon,&nbsp;I have also tried this before but it won't work either. &nbsp;Remember I am trying to make a dynamic dimension which means I need a column to change value when a measurement does. &nbsp;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.&nbsp;What Power BI here really needs is a global variable that can be interchanged among tables and measurements.

v-sihou-msft · Answer

TAlvarez
&nbsp;
Now variables are only available within&nbsp;the expression where you define them. You can vote this idea (global variable) here.
&nbsp;
Regards,

Forum Discussion

Dynamic Column based on aggregated measure

6 Replies

Related content

Dynamic measure filtering

Dynamic Measure developement

Slicers on Aggregated Measures

Dynamic Measure with Fieldparameters

Data Aggregation issue