Measure showing incorrect value in table

[Saxon202202]

Hi,

I created measure for total based on the column in data table column and measure but the total showing is incorrectly in visual table.

NO OF UNIT REQ = ROUND(IFERROR(VALUE([SUM OF QTY])/CALCULATE(SUM(DATA[PER PACK QTY])),0),0)

Also the sum of row level showing is incorrectly in stacked chart.

TOTAL UNIT REQ = [NO OF PACK REQ]*CALCULATE(SUM(DATA[PER PACK VOLUME]))

Can you please advise why it's showing incorrect vale in table and stacked chart and how can I fix the problem. 

 Herewith attached the PBI and snapshot for your reference. 

https://www.dropbox.com/s/2j1cjvtgxxieqtu/DATA-VAR-I-23-08-2022.pbix?dl=0

https://www.dropbox.com/s/oztxsd6ztrj4co7/ERROR%20SNAPSHOT.PNG?dl=0

[Ashish_Mathur]

Hi,

Why are there so many tables L01, L02 etc?  What is the purpose of creating those tables?

[MFelix]

Hi @Saxon202202 ,

Can you please explain a little bit better what is the result you are trying to achieve?

When I look at the measure that you have for the sum of quantity, you deriving your error since you are making it based on the MAX value so your calculation will always pick up the color L7.

[Saxon202202]

@MFelix ,

Thanks for your reply. I attached the snapshot for desired result.
For query1

For query2