Forum Discussion
Helper IIIIf Measure between two measures not summing properly
Coalesce (
[PROJECTED_SALES_Rev],
[Bud_Sales_Rev_ALL]
)
Coalesce returns the first nonblank result from the supplied parameters
If you expect 0 rather than blank
Switch (
True,
[PROJECTED_SALES_Rev] > 0, [PROJECTED_SALES_Rev],
[Bud_Sales_Rev_ALL] > 0, [Bud_Sales_Rev_ALL]
)
Since you as checking this per rows ina table you might have to use sumx.
Sumx(
Values( table[column]),
Switch (
True,
[PROJECTED_SALES_Rev] > 0, [PROJECTED_SALES_Rev],
[Bud_Sales_Rev_ALL] > 0, [Bud_Sales_Rev_ALL]
)
)
Helper IIIThanks for the ideas, I've tried just about everything the first column is for projections and are only about 3 months. I would like to use Budget amount for any that doesnt contain a projection. That's the second column totals never add up. They are the same as the projection column even though both show different amounts.
Hi, jimrosser
Have you solved your problem yet? If not, can you provide example files and what output you expect?
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.