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.
Hi,
Share some data, describe the question and show the expected result.
Hi Ashish, I've sent you a DM because some data may be sensitive. Could you kindly please check your inbox?
Just a small tweak needed.
Column = A || B || C isn't correct syntax for what you are wanting to do.
Instead, one way to write your Sold To Customer Group Name conditions is this (using the CA_vol example):
Customer[Sold To Customer Group Name] IN { "HOME DEPOT GROUP", "LOWE'S GROUP", "ADVANCE GROUP" }
You can also write it this way, but I would recommend the first option.
Customer[Sold To Customer Group Name] = "HOME DEPOT GROUP" || Customer[Sold To Customer Group Name] = "LOWE'S GROUP" || Customer[Sold To Customer Group Name] = "ADVANCE GROUP"
Also, for your final RETURN statement, I think you want this, which is the sum of the three variables defined earlier:
RETURN
CA_vol + all_vol + CT_vol
Regards,
Owen
Hi Owen,
Thank you for your reply. I tried both methods, but it doesnt seem to work and is still returning the same error.
For the RETURN part, if I sum them all up, like you did above, it shows one value for all customers (example: 1,7000,200)
Any other ideas?
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |