Forum Discussion

Otto_Luvpuppy's avatar
Otto_Luvpuppy
Helper II
6 years ago
Solved

Reference a Measure in a Table Cell

Hi, is it possible to reference a Measure in a table cell? For example I have a Measure called [Overdue] and I want to call it and manipulate it in a table cell like this; 19/20-P13 =[Overdue] ...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    6 years ago

    Otto_Luvpuppy , you can not refer a measure in a column, But you can create the below formula

    new measure =Switch( True(),
    Max(Table[column]) = "19/20-P13", [Overdue]
    Max(Table[column]) = "20/21-P1" ,[Overdue]*0.9
    Max(Table[column]) = "20/21-P2" ,[Overdue]*0.8
    Max(Table[column]) = "20/21-P3" ,[Overdue]*0.7
    Max(Table[column]) = "20/21-P4" ,[Overdue]*0.6
    Max(Table[column]) = "20/21-P5" ,[Overdue]*0.5
    Max(Table[column]) = "20/21-P6" ,[Overdue]*0.4
    )

     

    Take care of row context while using

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi Otto_Luvpuppy 

You need to define a rate column for each period, create a measue [Overdue] * average('Table'[Rate])

 

Regards,

Lin

Otto_Luvpuppy's avatar
Otto_Luvpuppy
Helper II
6 years ago

Hi Lin,

The trouble with that method is that I can't then plot it across a line as I will have 7 column rather than one.
The reason I need to do this is to plot a target line....we are only at P2 at the moment but I need to show a

steady decrease on the target line out to P6.
The use of Switch, given as a solution earlier certainly gives me the correct figures so I'm going to try to work with that.

 

Thanks for your help though...much appreciated.