Forum Discussion

Whatever1's avatar
Whatever1
Helper I
5 years ago
Solved

Measure Only Showing for Some Rows

I have the following data table: I want a matrix that always compares the amounts to the big amounts. I created a measure that I thought would always give me the total of all the Big amounts: ...
measure
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Whatever1 , if you want such a result,

    you might want to try this measure

    AllBig = 
CALCULATE (
    SUM ( [Amount] ),
    Table1[Group] = "Big",
    ALLEXCEPT ( Table1, Table1[Color] )
)
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

Hi, Whatever1 , if you want such a result,

you might want to try this measure

AllBig = 
CALCULATE (
    SUM ( [Amount] ),
    Table1[Group] = "Big",
    ALLEXCEPT ( Table1, Table1[Color] )
)
  • Whatever1's avatar
    Whatever1
    Helper I
    5 years ago

    CNENFRNL 

     

    Thank you! I have been banging my head against the wall with this and just couldn't figure out why it wasn't working.