Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sum of separate code

amount account code     account code   10 1     1 15 5 2 result->   2 10 30 7     7 30 5 1         5 2           Create 3 different measurements i...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may create the measures like below:

    Measure 1 = CALCULATE(SUM('Table'[amount]),'Table'[account code]=1)
    Measure 2 = CALCULATE(SUM('Table'[amount]),'Table'[account code]=2)
    Measure 3 = CALCULATE(SUM('Table'[amount]),'Table'[account code]=7)

    Regards,

Gopal30's avatar
Gopal30
Helper I
7 years ago

Why don't you use Matrix visualization i think it will give you the same result.