COUNT IF using a measure

[Anonymous]

Hi!

I have been searching for a way to solve this problem, but can't get it to work - so trying here instead. 

I have a DAX IF-formula like below for calculating new customers: 

IF([Sales Previous 4weeks TY] >0, IF([Sales Previous 4weeks TY] = [Sales Previous X-Months TY], 1, 0)

The problem is that it will not count the number of customers..  How can I solve this the easiest? Any count formula and/ or other idea?

Thanks in advance!

[Anonymous]

Hi and thanks for a quick reply, 

@MFelix  I have now created a sample file as show exactly the same issue as I getting with my real data. 

As you see here is the bottom row showing "0", the number I am after here is 3.

[MFelix · Accepted solution]

Hi @Anonymous,

Based on the calculation you present you need to have a SUMX to calculate this values something similar to:

Measure = SUMX(Values(Table[Customer), IF([Sales Previous 4weeks TY] >0, IF([Sales Previous 4weeks TY] = [Sales Previous X-Months TY], 1, 0) )

However looking at your formula this probably will not work correctly because of context. What you need to do is to calculate all a summarize table with the values of the customers and both measures.

In order to give you the correct resutls, can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.