topic Re: Dax values not coming for row level in DAX Commands and Tips

Dax values not coming for row level

jeffgreen6040 — Mon, 20 Apr 2020 04:06:21 GMT

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

Re: Dax values not coming for row level

Anonymous — Mon, 20 Apr 2020 05:01:02 GMT

Hi jeffgreen6040 ,

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

Cheers

CheenuSing

Re: Dax values not coming for row level

jeffgreen6040 — Mon, 20 Apr 2020 10:48:43 GMT

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.

Re: Dax values not coming for row level

jeffgreen6040 — Mon, 20 Apr 2020 10:53:50 GMT

Anonymous - This is how the final table should look like