Forum Discussion
Custom calculation help!
Hello! I need a bit of help creating this dax formula for my report.... First, I am trying to make a formula for the Ideal Points for my report. I have created measures for Rank1, Rank2, Rank3, an...
If I understand correctly you can use SWITCH to tell Power BI which rank measure to use:
Rank Value =
SWITCH( [Rank],
1, [Rank1]
,2, [Rank2]
, 3, [Rank3]
,4, [Rank4]
)
Then Multiply that by the points/modules to get the ideal points. Hope that makes sense?