Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No"
Els
Solved! Go to Solution.
Hello @sbhan4 ,
Try this:
GPPCheck =
SWITCH(
TRUE(),
SUM(GPP[Height]) <= 0 ||
SUM(GPP[Lenght]) <= 0 ||
SUM(GPP[Width]) <= 0,
"No",
"Yes"
)
I hope it helps.
Best regards
Fernando
If it helped, please consider liking the post and mark it in response.
@Anonymous
Are you using Width or Weight?
F
@Anonymous
You're not showing the Width column in your screen-shot. It'd be helpful if you share a sample of your data.
F
Hello @sbhan4 ,
Try this:
GPPCheck =
SWITCH(
TRUE(),
SUM(GPP[Height]) <= 0 ||
SUM(GPP[Lenght]) <= 0 ||
SUM(GPP[Width]) <= 0,
"No",
"Yes"
)
I hope it helps.
Best regards
Fernando
If it helped, please consider liking the post and mark it in response.
@calerof Hello sir,
I tried your solution. Everything showing "YES" only. As you see in the screenshot,
if any of the column value is 0 or blank = NO
Each column has a value >0 then only YES. can you share your pbix file.
Hi @Anonymous ,
You are doing it the opposite way, and that's fine. You just have to change the OR for AND.
Cheers,
Fernando
What is your code for GGP now?
Hi,
As you can see in the screenshot, the code is the same as you told. Now I changed || to &&.
Please provide a sample of your data with your pbix file to help you.
F
@calerof I have updated the screenshot with a width column. Please help me with that.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |