Need a Dax Measure Formula for If Statement

[Sean-OReilly]

Hi 

I need a measure formula for - if vendor rating = 1, then "sub with insurance", if vendor rating = 3, then "sub no insurance", if not 1 or 3 then "Review and fix"

[amitchandak · Accepted solution]

@Sean-OReilly ,

as measure

Switch( True(),
max([vendor rating]) = 1 , "sub with insurance",
max([vendor rating]) = 3, "sub no insurance",
"Review and fix"
)

as column

Switch( True(),
[vendor rating] = 1 , "sub with insurance",
[vendor rating] = 3, "sub no insurance",
"Review and fix"
)

[Sean-OReilly · Accepted solution]

Thanks for coming back to me Amitchandak

Unfortunately the measure did not work for me.

Did i type it correctly?

Vendor Rate Description = switch(true(),max(PURCHASE_ACCOUNTS[VENDOR_RATING])=1, "Subbie with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=3, "Labour Only with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=2,"Subbie No Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=4, "Labour Only No Insurance","Review & Fix")

[Sean-OReilly · Accepted solution]

Thanks for coming back to me Amitchandak

Unfortunately the measure did not work for me.

Did i type it correctly?

Vendor Rate Description = switch(true(),max(PURCHASE_ACCOUNTS[VENDOR_RATING])=1, "Subbie with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=3, "Labour Only with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=2,"Subbie No Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])=4, "Labour Only No Insurance","Review & Fix")

[amitchandak · Accepted solution]

@Sean-OReilly , is vendor rating a text column, if yes then try

Vendor Rate Description = switch(true(),max(PURCHASE_ACCOUNTS[VENDOR_RATING])="1", "Subbie with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])="3", "Labour Only with Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])="2","Subbie No Insurance",max(PURCHASE_ACCOUNTS[VENDOR_RATING])="4", "Labour Only No Insurance","Review & Fix")

[Sean-OReilly]

Sorry - 1 last question on this.

Is there a way to remove "Review & Fix" from the Total Row in the Table Visual?

[Sean-OReilly]

You are a Legend - thanks a million man

[amitchandak · Accepted solution]

@Sean-OReilly ,

as measure

Switch( True(),
max([vendor rating]) = 1 , "sub with insurance",
max([vendor rating]) = 3, "sub no insurance",
"Review and fix"
)

as column

Switch( True(),
[vendor rating] = 1 , "sub with insurance",
[vendor rating] = 3, "sub no insurance",
"Review and fix"
)