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

amitchandak's avatar
amitchandak
Super User
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

  • Otto_Luvpuppy's avatar
    Otto_Luvpuppy
    Helper II
    6 years ago

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

    Thanks for your help