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.
Hello.
I would need your help please with a bit complex multiple if statement with multiple conditions where I struggle with some issues.
This is my dax:
Issues:
1. I want to assign specific rates in different and multiple buckets but the results are not the expected.
I start with the below for exmaple:
Solved! Go to Solution.
Hi, @vbis ;
The last DAX can be simplified to and could try it.
Rates =
IF (
( Clothes[Color] IN { "White", "Black" }&& [Units Sold] = "Low" )
|| Clothes[Color] = "Grey",
SWITCH ( [Size], "Small", "5", "Medium", "10", "Large", "15" ),
"null")
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @vbis ;
Perhaps you can reduce the performance of the data itself and optimize the performance. Or optimize the data itself in the power query for ETL data processing.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello.
Apparently, I still struggle with this.
I reduced the volume of the data (total number of rows now 1,408,856) and I also tried to simplify a bit the formula and i still get invalid results.
So, my dax now is:
Hi, @vbis ;
The last DAX can be simplified to and could try it.
Rates =
IF (
( Clothes[Color] IN { "White", "Black" }&& [Units Sold] = "Low" )
|| Clothes[Color] = "Grey",
SWITCH ( [Size], "Small", "5", "Medium", "10", "Large", "15" ),
"null")
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello.
Thank you for your response.
I tried this dax and i got the message:
"Something went wrong. There's not enough memory to complete this operation. Please try again later when there may be more memory available."
@vbis , check the data in the Size column any white space or case(Upper/Lower) issue. Overall formula looks correct
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |