Measures not calculating in table

[mwen90]

Hey,

I got one column which has three values which I need to count the totals on. Ie. Total - Pizza, Spaghetti, Ice Cream.

I've created 3 measures so I can count the amount of sales and estimates against pizza / spaghetti / ice cream. But when I put it in a table the measures don't add up properly. 

I can't create columns because of a depedency. I tried using 'values' and 'hasnofilter' but neither worked.

Does anyone have any tips?

Thanks!

[mwen90]

Thanks @Dhacd 

My equation: 

IF(SUM('Table'[Scheduled]) = 0, [Measure 12], IF(SUM('Table'[Measure]) =0, SUM('Table'[Scheduled]), IF(SUM('Table'[Column 3]) >= 1, [Measure 21] + [Measure 12],if(SUM('Table'[Scheduled]) > [Measure 12]*.8,SUM('Table'[Scheduled]), [Measure 12]))))

The number underlined in the table is the only item which is wrong. It is 1839 in total, it should be 2071. The Blanks should be missing as well. 

Please note: I am doing a SUMX on the equation above. If I put 'Level' first, the table doesn't calculate. 

Measure 24 = SUMX(SUMMARIZE('Table','Table'[Element], 'Table'[Building], 'Table'[Level]), [Measure 23])

Thanks so much for the help!

[mwen90]

Thanks Atma,

I tried to copy the data into an excel to demonstrate but it's quiet complex and private. 

Can we do a screen share?

Cheers,

[Dhacd]

Please share the sample table as well as the measure used.

Regards,
Atma.