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, and Rank4 points (this is a formula given to me by my company which is the number of team members * a percentage of people).
I need to calculate the Ideal Points by doing this: Rank1 * number of modules with a rank 1 for the course = rank 1 ideal points.
(so for this highlighted row... I need the Rank1 * 12 = rank 1 ideal points for WW L100 M02 Computer screens)
I am also wondering if I could create this table like the pivot table below.... Thanks in advance!
1 Reply
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?
