Forum Discussion

Whatever1's avatar
Whatever1
Icon for Helper I rankHelper 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] )
)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Whatever1 , Try like

AllBig = calculate(sum([Amount]),filter(Table1,Table1[Group]="Big"))

Whatever1's avatar
Whatever1
Icon for Helper I rankHelper I
5 years ago

That makes it show on only one row: