Forum Discussion
nataliesmiy1357
Helper IV
Helper IVCustom 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...
AllisonKennedy
Community Champion
Community ChampionIf 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?