Count distinct customers having sales

Question

Hi everyone,&nbsp;I m new to Power BI and struggling with Power BI DAX.I'm trying to count&nbsp;Distinct customers having sales. It means when selecting relevant months, only customers having sales will be counted.&nbsp;I used the following measure:"CALCULATE(DISTINCTCOUNT(Rawdata[cust code]), FILTER(Rawdata, CALCULATE(SUM(Rawdata[f_Value]), ALLEXCEPT(Rawdata,Rawdata[cust code]))&gt;0))"Error: It does not work with the condition "having sales &gt; 0". For example, I select Oct 2019, it counts all distinct customers, including customers having sales &lt; 0. I think the Filter function does not work, it just summerize the sales of customers of any time, not based on the months that I selected (ex Oct'19).&nbsp;Hope that you can help me on this issue.Thanks a lot in advance!&nbsp;

anonymous · Answer

LinhDO&nbsp;Please use this measure. In case this is not what you expected, share some dummy data along with expected result Measure = CALCULATE(DISTINCTCOUNT('Table'[cust code]),FILTER('Table','Table'[f_value]&gt;0))&nbsp;

linhdo · Answer

Hi,&nbsp;Your syntax does not work as i expect.You can see the raw data on this link:https://drive.google.com/file/d/1tneUjqd7rpk9dHkcjgodw2UNtQb41Roi/view?usp=sharing&nbsp;In sheet "Raw", total customers in a month, 1 customer can purchase more than 1 time. When calculating active customers in a month, I use pivot to summarize sales by cust code then count 1 if sales by cust code in a month &gt; 0.&nbsp;Hope its clear. 🙂thx a lot!

Forum Discussion

Count distinct customers having sales

2 Replies

Related content

count distinct

Custom Visual

Distinct Count

count Distinct customers per month

how to filter out to have only distinct values