MTD and Matrix Not Behaving as Expected

[pawlowski6132]

I'm including two errors as they may be related.

I have measures that work on a daily basis. 

For example, on 1/3/21, the Total Expense if work a shift is $6,945. We worked 0 shifts so the Planned Total Expense was $0.

on 1/4/21 the planned Total Expense is $7,250, we worked three shifts so the Planned Total Expense was $21,749.

Now 1) The MTD is all hosed up, where are those numbers coming from? 2) the Total of the Total Expense per Day colum,n is $25,685. What is that supposed to be? The total SHAP MTD Planned Total expense is 63x25,685 but why?

I don't even know where to start. Any suggestions on what could be causing these issues. I've spent over 1/2 day trying to understand this. Ugghh. 

Thanx in advance.

[Icey]

Hi @pawlowski6132 ,

How do you create the measure? Can you share us some sample data for test?

Reference: How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@pawlowski6132 you have given the partial information, paste the data in a table format (or excel file), and share what is your expected result. It is not clear from your post what kind of MTD calculation you are doing. Share file thru one drive/google drive.