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.
Super UserHi,
Share the download link of the PBI file. Show the problem and the expected result very clearly.