Need help with Sum of the lowest cost option

[NW953]

I have 4  DAX measures that calculate the cost for that option for each user. Lets call them License1, License2, License3, License4

They all work correctly and sum for all users, etc.

I need to calculate what the lowest cost option is for each user (email), then also have a columm total that is the SUM of the lowest cost option for each user. I used SWITCH to return the lowest cost option and it works, but does not sum.... I am not tied to using SWITCH though

Thanks for your help in advance

[vicky_ · Accepted solution]

I'm going to assume that you have some kinda table with a column for all the users.

If so, then something like the following might work:

Total Min Cost = 
var minCostPerUser = ADDCOLUMNS(VALUES(UserTable[UserEmail]), 
    "minCost", CALCULATE(MIN(MIN(MIN([License1],[License2]),[License3]),[License4]))
)
RETURN SUMX(minCostPerUser, "minCost")

You can post a sample of your data (i.e create a table) and someone else can tag in if my solution isn't what you're looking for