Forum Discussion
Nested IF Statements
I'm trying to create flags for various pricing levels on our accounts.
So far they're in separate IF statements in this rough logic:
IF Monthly Fee = $45.99 then Monitoring Plan = Standard,
Monitored By = DirectTV,
Interactive Service Providers = ATT&T(DTV),
Activation Fee = $89,
Warranty Term = DTV Qolsys
IF Monthly Fee = $55.99 then Monitoring Plan = Premium,
Monitored By = DirectTV,
Interactive Service Providers = ATT&T(DTV),
Activation Fee = $89,
Warranty Term = DTV Qolsys
IF Monthly Fee = $63.99 then Monitoring Plan = Platinum,
Monitored By = DirectTV,
Interactive Service Providers = ATT&T(DTV),
Activation Fee = $129,
Warranty Term = DTV Qolsys
How would I combine these into one logical statement?
Alta88 try this
First Create 2 table as per below
Then put monthly fee column in filter slicer
now create one measure as per below
Result = var _s = SELECTEDVALUE(Fee[Monthly Fee])
return
IF(HASONEVALUE('Table'[Deatils]),
IF(_s = 45.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "89.99",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Standard",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))),
IF(_s = 55.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "89.99",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Premium",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))),
IF(_s = 63.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "129",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Platinum",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))), "Please Select Plan"))))Finally ceate table into visualisation as per below:
2 Replies
Alta88 try this
First Create 2 table as per below
Then put monthly fee column in filter slicer
now create one measure as per below
Result = var _s = SELECTEDVALUE(Fee[Monthly Fee])
return
IF(HASONEVALUE('Table'[Deatils]),
IF(_s = 45.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "89.99",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Standard",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))),
IF(_s = 55.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "89.99",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Premium",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))),
IF(_s = 63.99,
IF(SELECTEDVALUE('Table'[Details]) = "Activation Fee", "129",
IF(SELECTEDVALUE('Table'[Details]) = "Monitoring Plan", "Platinum",
IF(SELECTEDVALUE('Table'[Details]) = "Monitored By", "DirectTV",
IF(SELECTEDVALUE('Table'[Details]) = "Interactive Service Providers", "ATT&T(DTV)",
IF(SELECTEDVALUE('Table'[Details]) = "Warranty Term", "DTV Qolsys"))))), "Please Select Plan"))))Finally ceate table into visualisation as per below:
Thank you very much! This is a huge step forward for me.
