Summing a Calculated Field

[jw80]

I have data at a store level that is repeated for each item int he store in the dataset.  Each store has the same value regardless of the item in the Sum of MOD LINEAR column.  In the example, this data is 1,920.  At the total for store 1060 and store 1527, the total is 55,680, which is a summation of 1,920 for each item.  I only want the total line for the store to show 1,920 until it gets to the grand total, which should be 3,840 (two stores at 1,920 * 2).  Any suggestions on how to write a formula to get it to return these calculations would be apprecitated.  Thank you.

 

[jw80]

Please see attached for the report.  I believe you should be able to view/download.

https://app.powerbi.com/groups/me/reports/f1a36b22-e921-4545-93ee-14a7474921d0?ctid=95e66ecc-f2c2-46...

In addition to the initial request, ITEM LINEAR is a calculated field.  I'm also trying to get the total to sum ITEM LINEAR and not calculate based on the sums of H FACINGS AND ITEM WIDTH.

[Ashish_Mathur]

That is not a download link.

[Ashish_Mathur]

Share the download link of the PBI file.