Discrepancy in measure output when used in column chart with/without legend

[mahawkins3]

Hi,

I have a measure which calculates total fees projected for the current month (e.g. if there is data up to April 3rd, it will divide by 3 and multiply by 30 to calculate a simple full-month forecast). See below:

When I put this into a stacked column chart, breaking the fees down into different types, the respective chunks of the stack add up to the correct total (let's say 60k). However, when I remove the "fee type" parameter from the legend and just show a single block for all fees, it calculates a different value (50k). This seems strange to me, because the underlying calculation going into both should be the same (regardless of whether I subdivide the values using a legend) - it's using the same data, so the MAX([SettlementDate]) calculation should return the same value either way. The issue seems to be that when it generates the visual with the single column (no legend), it reads the MAX([SettlementDate]) as being one day further ahead than it should be, so the total comes out lower than it should.

Any idea why this would be happening?

The only reason I'm trying to calculate both ways is that Power BI doesn't allow you to put a total at the top of a stacked column, so I want to put the "total" version behind my stack so the value shows above my stack... problem is it's giving me the wrong total!

Thanks in advance,
Matt

[v-huizhn-msft]

Hi @mahawkins3,

>>if there is data up to April 3rd, it will divide by 3 and multiply by 30 to calculate a simple full-month forecast.

Based on my understanding, you should use Day(Today()) rather than Day(MAX(Fees[SettlementDate])) in DIVIDE() function. 

In addtion, I am still confusing your requirement. Is there any chance to post your sample data or screenshot for analysis? So that we can post solution which is close to your requirement.

If you have other issues, please feel free to ask.

Best Regards,
Angelia