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:

 

AllBig = calculate(sum([Amount]),Table1[Group]="Big")
 
However, my matrix only shows the AllBig amounts that are in the same section and not for the other rows:
 

How do I get AllBig to show for all Sections?

 

This example isn't realistic but I tried to simplify the issue to the smallest set of data that showed the problem.

 

 

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] )
)

4 Replies

  • 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.