Count num. of customers with sales grand total >=100

[Zaoka]

Hi,

Can you help me with the creation of custom measurement that would count number of customers that have Grand total sales greater than 100$

I created this measurement, that count active customers per Sales person and brand if net sales per brand is greater that 0

=COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE(SalesSource;SalesSource[DSDBC]);"zaoka";MAXX(VALUES(SalesSource[Brand]);CALCULATE(SUM([Net sales value $]);ALL(SalesSource[Net sales value $]))));[zaoka]>0))

but i don't know how to add code that would first check sales grand total per customer and if sales is >=100$ then count that customer as active per brand.

This is Example of data

https://www.dropbox.com/s/79dh21slo42c1hi/Count%20example.xlsb?dl=0

 

[Zaoka]

I don't think i can normalize data, because this is daily sales, and some thing are always changing.[FONT=arial, sans-serif] [/FONT]

I thought I could combine my code from first post with your solution.... somehow to put in this part

SUM ( Sales[Net sales value $] ),
ALL ( Products[Brand] )
) >= 300

 

[Zaoka]

I did it, thanks a lot for the idea and the help

=COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE(SalesSource;SalesSource[DSDBC]);"zaoka";MAXX(VALUES(SalesSource[Brand]);CALCULATE(SUM([Net sales value $]);ALL(SalesSource[Net sales value $]))));[zaoka]>0&&CALCULATE(SUM(SalesSource[Net sales value $]);ALL(SalesSource[Brand]))>=300))

So for all other users this code count unique customers that have total Sales greater than e.g. 300 and then count customers with sales per brand greater than 0

 

[VBA Geek]

I don't think i can normalize data, because this is daily sales, and some thing are always changing.

You could add a Date dimension as well in order to analyze it by Date