Forum Discussion

Helper III

1 year ago

Solved

Measure that References other Measure based on a conditional Column

Hi All , I'm looking at making this type of logic into a measure but not sure how to : CC 2 = If CC 1 = -1 then = 0 If CC 1 = 0 then use "Total Solar" If CC 1 = 1 then use "Total Cons" I...

Need Help

SamWiseOwl
1 year ago
So CC1 is a calculated column that will appear in the visual and the other items listed are all existing measures?
CC2 =
Switch(
SelectedValue(table[CC1])
,-1, 0
,0, [Total Solar]
,1, [Total Cons]
,2, [BP 1] - [Nursery]
,3, [Art Design] - [MFL & Humanities and Thornton]
,4,[Main School] - [Art & Design]
)

Anonymous

Not applicable

1 year ago

Your solution is worked perfect SamWiseOwl

Hi, JamesBurke

I've created this example data:

I have a cc1 conditional column:

Then use the SamWiseOwl measure:

CC2 = SWITCH(TRUE(),
SELECTEDVALUE('Table'[CC1]) = -1,0,
SELECTEDVALUE('Table'[CC1]) = 0,[Measure1],
SELECTEDVALUE('Table'[CC1]) = 1,[Measure2],
SELECTEDVALUE('Table'[CC1]) = 2,[Measure3]
)

It works flawlessly: