Custom calculation help!

[nataliesmiy1357]

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!

[AllisonKennedy]

@nataliesmiy1357 

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?