Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
vissvess
Helper V
Helper V

Total of measure results count error

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
Capture.JPG
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
 
4 REPLIES 4
Anonymous
Not applicable

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

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
Not applicable

Do you have a dual storage model?

Best
D.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors