Sumx not calculating the grand total

[Anonymous]

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!

[mlsx4 · Accepted solution]

Hi @Anonymous 

Maybe you can try:

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

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

[Anonymous]

Thank you very much! Worked like a charm 🙂