Reference a Measure in a Table Cell

[Otto_Luvpuppy]

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]
20/21-P1	=[Overdue]*0.9
20/21-P2	=[Overdue]*0.8
20/21-P3	=[Overdue]*0.7
20/21-P4	=[Overdue]*0.6
20/21-P5	=[Overdue]*0.5
20/21-P6	=[Overdue]*0.4

Any ideas?

Thanks

[v-lili6-msft]

hi @Otto_Luvpuppy 

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

Regards,

Lin

[Otto_Luvpuppy]

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.

[Tahreem24]

@Otto_Luvpuppy ,

You can take measure into another measure directly without any aggregation. 

New Measure = [Measure]*0.78

Is there any logic on multiplication factor (i.e. 0.4,0.5 etc.) ?

[Otto_Luvpuppy]

Hi...thanks for the help...yes the reason behind this request is that I'm trying to build a decreasing 'target' across the 6 period dates. The only information I have is a static figure for Period 13 and that they want to reduce this by 60% when they get to Period 6. So it's a flat line and works out as a 10% decrease each period based on the original Period 13 figure.

Regards

[amitchandak · Accepted solution]

@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

[Otto_Luvpuppy]

This looks interesting....I'll give it a try.

Thanks for your help