Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |