Hi, I’ve been trying to calculate the grand totals but I don’t understand why it is not calculating the right amount.
Below you can see the table with the amounts that I have in different measures.
As you can see the total that PBI calculates is showing 83.24 when the correct amount for the net expense is 69.05. Because of this issue, I’m having incorrect grand totals for all my PR calculated measures. Now, the PR TCE Cal takes the total of PR Net revenue - PR Net expenses and then divides the total by the 31 days. I notice that the PR TCE Cal is correct per line but the total amount is incorrect since it is taking the incorrect totals of the revenue and the expenses.
This is the DAX code I’m using for the measures
PR TCO Hire = VAR TotalTCOHire = SUMX('VPR Raw Data','VPR Raw Data'[TCO Hire]) VAR TotalVoyageDays = SUMX('VPR Raw Data','VPR Raw Data'[Voyage Days]) Return DIVIDE(TotalTCOHire,TotalVoyageDays) * [Prorated days]
Can anyone please share some light on this issue?