How to calculate active customers current and previous month by customer code
Good day. ROA=running of account I wanted to get the previous month active customer by using: Previous Month ROA = CALCULATE (DISTINCTCOUNT('Running of Account'[Debtor Code]), PREVIOUSMONTH('Running of Account'[Date])) But i got no value. For current month ROA I'm using: Current Month ROA = CALCULATE ( DISTINCTCOUNT('Running of Account'[Debtor Code]), YEAR( 'Calendar'[Date]) = YEAR(MAX('Calendar'[Year Month])), MONTH( 'Calendar'[Date]) = MONTH(MAX('Calendar'[Year Month]))) And for current month is fine. May I know where I have do it wrong? Below are my example data. Calendar table Running of account data: Thank you so much.
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!
