Forum Discussion

vojtechsima's avatar
vojtechsima
Icon for Super User rankSuper User
2 years ago

Hi, dshah12 ,

bit confusing, but do you want it like this?

Measure:

Total Difference = SUMX('Table', 'Table'[sum of fore] - 'Table'[recomm])
dshah12's avatar
dshah12
Icon for Helper II rankHelper II
2 years ago

Hi thank for the reply but this formula will sum the recomm amount I don't want that it should be without that 

  • vojtechsima's avatar
    vojtechsima
    Icon for Super User rankSuper User
    2 years ago

    dshah12 but how do you wanna they display it, you can see that if you put to each line, it's not a sum, but it i a individual level.

    Do you want it as calculated column then, or could you give me please example of the result?