Sumx not calculating the grand total

Anonymous — Wed, 19 Jul 2023 10:20:28 GMT

Hi everyone,

First ever post.

I'm struggling to get the right formula for my solution.

I have a calculated column which follows the logic:
Products bought =
IF( A = 0 && B = 1, 1, 0)

I get the correct output:

Product A 1
Product B 2
Product C 1

Client is asking if the product appears just once, show it as 1, not a 2, so it would be like

Product A 1
Product B 1
Product C 1

Since it's a calculated column, i tried to use this formula for a solution:
IF(SUMX('Table','Table'[Products Bought]) >= 1, 1, 0)

Now I get the proper counts, but I can't get to show the result as a GRAND total or SUB Total.

How do I fix this?

Does my logic make sense?

Thank you in advance DAX guru's!

Re: Sumx not calculating the grand total

mlsx4 — Thu, 20 Jul 2023 06:53:49 GMT

Hi Anonymous

Maybe you can try:

SUMX(VALUES('Table'[Product]),[Measure])

Where [Measure]=IF(SUMX('Table','Table'[Products Bought]) >= 1, 1, 0)

Re: Sumx not calculating the grand total

Anonymous — Thu, 20 Jul 2023 07:08:11 GMT

Thank you very much! Worked like a charm 🙂

topic Re: Sumx not calculating the grand total in DAX Commands and Tips

Sumx not calculating the grand total

Re: Sumx not calculating the grand total

Re: Sumx not calculating the grand total