Table missing - Two values

[Anonymous]

Hi Experts

I cannot get my measure to populate the values for Total Logistics and Total Logistics (excl Duty) the measure populates the values for the other metrics...

I cannot see the error in my measure..

See Logistics Table for all details

Sample PBIX link

https://www.dropbox.com/s/r7t18dwp01tpyr2/PLP_Test_3.pbix?dl=0 

Sample Excel File with Data

https://www.dropbox.com/scl/fi/qe5z8taafa5t4208nrnh8/ExcelSample.xlsx?dl=0&rlkey=igs7wpbtpn9erbxo0gi... 

[HotChilli]

Thanks for the pbix.  I feel that the question could have been made a bit clearer for a number of reasons : it's a complex model, the fields in the table have been renamed, there are a number of filters/slicers applied to the table and so on.  So please give us a bit more info next time.

As regards to the issue at hand. The GrpID in Logistics table on the 2 Total Logistics fields are z22, z23.

The Logistics table relates to the PL table with GrpID->SNO and there is no data in the PL table with SNO of z22 or z23.

Either the data is missing or the relationship is set up wrongly.  I notice there is a GrpSno field in the Logistics table but I haven't investigated further.

[Anonymous]

Hi HotChilli, ok how would you create a new row in the Table called Total Logistics... But do the following Maths 

Total Logistics = Inboud Freight + Duty +Warehousing - fixed + Warehousing - variable +Sc&L People +Outbound Freight... using DAX

Adding new PBIX where i have created a new grp id.... to sum the above...

This might help...

https://www.dropbox.com/s/r7t18dwp01tpyr2/PLP_Test_3.pbix?dl=0