Count rows from filtered measure
I have tried and tried to look for a solution, and didn't find anything that wasn't confusing. I must be over thinking this... Here is my data, it's so very simple...only one column named Animal, with 16 rows. I am looking for a measure that returns the distinct count of animals that are on the list once, and a distinct count of animals that are on this list more than once. So in this instance, that are a total of 9 different animals, 3 animals are listed once and 6 are listed more than once. Animal Lion Lion Bear Dog Cat Bird Bird Deer Monkey Monkey Cat Bear Beaver Beaver Beaver Moose I already have this
Count distinct customers having sales
Hi everyone, I m new to Power BI and struggling with Power BI DAX. I'm trying to count Distinct customers having sales. It means when selecting relevant months, only customers having sales will be counted. I used the following measure: "CALCULATE(DISTINCTCOUNT(Rawdata[cust code]), FILTER(Rawdata, CALCULATE(SUM(Rawdata[f_Value]), ALLEXCEPT(Rawdata,Rawdata[cust code]))>0))" Error: It does not work with the condition "having sales > 0". For example, I select Oct 2019, it counts all distinct customers, including customers having sales < 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). Hope that you can help me on this issue. Thanks a lot in advance!
