Can you please provide a sample of data in a .pbix file? You can create a link to it on OneDrive (the best option as I'm at work right now and will have a lot of trouble to get it down from Google Drive).
Since my PBIX file is connected to 5 sources for my 12 queries. 3 from an excel file, 1 from SQL server & 1 from a network folder, I am wondering how to share the file.
Let me try to explain to you.
The snapshot I shared, shows the DAX expression of the measure "Pallet requirement".
When the measure used in a table (shown below the expression), it is evident for me that the expression holds good for each rows in the table. But not for the total row. The total row is supposed to be sum of each row measure output. But that not the case that is happening.
Still in need of dataset for work arond, I will dig for a way to share the data.