Forum Discussion
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] |
| 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
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
6 Replies
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
This looks interesting....I'll give it a try.
Thanks for your help
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.) ?
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
You need to define a rate column for each period, create a measue [Overdue] * average('Table'[Rate])
Regards,
Lin
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 asteady 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.
