Summing the displayed results of a measure

[gvg]

Hi,

I've read a thread with the similar title, but my case is somewhat different. I have a measure:

New clients = IF([Sales in Previous Period]=0 && [Sales in Last Selected Month]>0
                          ,1
                          ,0)

How do I sum the New clients measure? I failed to do it with COUNT, as it requires a column reference as an argument.

[TomMartens · Accepted solution]

Hey,

w/o having more details about you model I guess you could use an iterator like this:

CALCULATE 
  (SUMX(
    VALUES('yourtable'[clientid])
    ,IF([Sales in Previous Period]=0 && [Sales in Last Selected Month]>0
                          ,1
                          ,BLANK())
)

I just replaced the zero from the FALSE part of the IF statement with BLANK(), avoiding to add meaningless values (from my point of view) to the RAM.

Hope this gets you started

Regards

Tom

[gvg]

@TomMartens , 

Yep, that works. Thank you very much.