Show sum in same column

[Anonymous]

hi Experts

I have two measures - which i would like to show as one. i the sum for the products in the same column but different row,,,,

Ostomy = CALCULATE(SUM(Taiwan[Amount]),FILTER(Taiwan,Taiwan[Products]="Ostomy"))

Ostomy1 = CALCULATE(SUM(Taiwan[Amount]),FILTER(Taiwan,Taiwan[Products]="Ostomy1"))

in a std table in a visual...

[v-yuta-msft · Accepted solution]

Hi Route11,

Your requirement is not so clear. Could you clarify more details about your issue and show the expected result?

Regards,

Jimmy Tao 

[Anonymous]

Hi Jimmy..

Apolgies i was bing silly SUMX does the try. thanks for the feedback