Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Solved! Go to Solution.
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"
)
Thanks for coming back to me Amitchandak
Unfortunately the measure did not work for me.
Did i type it correctly?
@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")
Thanks for coming back to me Amitchandak
Unfortunately the measure did not work for me.
Did i type it correctly?
@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")
Sorry - 1 last question on this.
Is there a way to remove "Review & Fix" from the Total Row in the Table Visual?
You are a Legend - thanks a million man
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"
)
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |