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

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
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
    Not applicable
    9 years ago

    Hi Phil_Seamark,

     

    Thanks for replying, yes it is possible to use it as calculate measure,

     

    What is want is for each id_indicator calculated column would be different as value would be different.

     

    if measure 5 is 50. (user select 50 as slicer value)

     

    id_indicator    hour   calculated column

    1                        9       50*9

    1                       10      50*10

    .........upto ............20      50*20

    2                       9        50*9

    2                       10      50*10

    ......upto......20.......

    ..for 1000 id_indicator

     

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

    Thanks.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      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