Dax values not coming for row level

[jeffgreen6040]

Hi, I need to create a report as shown in the attached upload. There are some formulas that needed to be created and i did created them in Pbix. Below are those formula's. Considering example : INV-0032490, Item – 00879, Sales Order SO-0071483 The Amount (Gross) = $924.00 ; Amount (Discount)=- $11.49 ; Amount (Net) = $912.51 (which is the difference of Gross and Discount). See attached screenshot Now, calculating discount for this particular case - INV-0032490, Item – 00879 Contribution per item : 924/47709.79 = 0.0193 Amount Discount = 0.0193 *(-593.05) = -11.49 (which is the discount attributed to this particular Item). Now, the problem is when i am creating a table visual my measures are not showing data in row level and it is only showing the total values instead of Individual rows. Below attached is the sample Pbix and the screenshot of the report what i am trying to create in Pbix

Sample pbix file here 

[Anonymous]

Hi @jeffgreen6040 ,

Can you share for the attached sample file what is the result expected by visuals, by measures etc.

Cheers

CheenuSing

[jeffgreen6040]

@Anonymous - This is how the final table should look like

[jeffgreen6040]

Thanks for your response. I am attaching the resultset that is expected.  The one highlighted in yellow is how it is suppose to appear and the values are correct however when i add any fields to it  like Class or Item Desc etc the values are changing to 0.00 for "Contribution per item" , Amount discount is coming as blank and  Amount net is changing to 924.00 from 912.51 highlighted in pink.  I want it to still calculate at line level as it was highlighted in yellow even when i add other fields like class or item desc or any other field.