Showing incorrect category in if statement calculated column, my formula is:
Hi @Anonymous ,
You are using sum in the visual.
Yet the category is calculated by each single row in the table.
So you will need to calculate the sum first then create category.
Best Regards,
Jay
Hi @Anonymous ,
You are using sum in the visual.
Yet the category is calculated by each single row in the table.
So you will need to calculate the sum first then create category.
Best Regards,
Jay
@Anonymous What is POR? Just a column, a measure or ?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
@Anonymous I can't replicate this, are you able to share your PBIX?
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
