Total of measure results count error

[vissvess]

Hi,

I have created a measure as following

Pallet requirement =

var PR =

ROUNDUP

(

DIVIDE

(

[Quantity],

SUM(PartVsCommodity[MOQ])

),

0

)

var TPR =

SUMMARIZE(PartVsCommodity,PartVsCommodity[Item number],"Actual total",PR)

return IF

(

HASONEVALUE(ConfigDetails[Chassis]),

PR,

SUMX(TPR,PR)

)

Yet, the table total doesnot sums the corresponding individual entry of the rows.

My data set & relation could be summarised as follows

Calander table related to Archive table (date column)

Archive table related to Config details table (Order number column)

Config details table related to partsvscommodity table (Chassis column)

Again, archive table related to time buckets table (Time column)

I am plotting a table as shown below

And, [Quantity] is a measure in archive table.

My problem is

the total of the pallet requirement column is not the acutal sum of the individual row entries.

Any kind help would be much appreciated.

Thanks

Vissvess

[Anonymous]

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).

Best
Darek

[vissvess]

Dear @Anonymous ,

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.

Thanks

[Anonymous]

Do you have a dual storage model?

Best
D.

[vissvess]

Do you mean the source is from two or more locations by "Dual storage models".?

If so, yes as mentioned in my earlier post.

If not, what is meant by dual storage model.

Thanks