Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

assign measure value to calculated column

I have created two tables:   User can see green field as slicer in sheet and on select, i have created measure in id_indicator table, Measure 5 = if(COUNTROWS('Input_Threshold') = 1, sum...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Hi Anonymous,

     

    PRobably not as a calculated column but you can do it as a calculated measure and you will probably get the result you are after, in that as you dynamically change the slicer selection your new calcuated meaure will reflect the values

     

    So try putting this measure on your main table and then create a matrix visual

     

    New Measure = 'Input_Threshold'[Measure 5] * [Measure 5]
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    >>so calculated column requires, is it possible with calculated measure to do for each indicator?

    Current, power bi not support use slicer value to work with calculate column.

    You should use measure to instead the calculate column.

     

    Regards,

    Xiaoxin SHeng

cnewell7's avatar
cnewell7
Icon for Helper II rankHelper II
8 years ago

If you do add a Measure as a Calculated Column, it will be the SAME for every Calculated column because no Query or Filter Context applies. I do not believe this is what you want

 

Not necessarily. If a relationship exists between the table with the calculated column and another table, then context transition will occur and you'll get a different result for every row

dani1640's avatar
dani1640
Icon for Advocate II rankAdvocate II
8 years ago

Yes! In fact! I need it :c

How can make it?