Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@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.
@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:
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |