topic Re: Measure Only Showing for Some Rows in DAX Commands and Tips

Measure Only Showing for Some Rows

Whatever1 — Wed, 25 Nov 2020 15:47:12 GMT

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.

Re: Measure Only Showing for Some Rows

amitchandak — Wed, 25 Nov 2020 16:51:48 GMT

Whatever1 , Try like

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

Re: Measure Only Showing for Some Rows

Whatever1 — Wed, 25 Nov 2020 17:51:59 GMT

That makes it show on only one row:

Re: Measure Only Showing for Some Rows

CNENFRNL — Wed, 25 Nov 2020 21:57:44 GMT

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

Re: Measure Only Showing for Some Rows

Whatever1 — Wed, 25 Nov 2020 22:18:15 GMT

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.