Forum Discussion

That_Analyst's avatar
That_Analyst
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Count blanks

I want to get the count of Customers from June that were not seen in July. So Count of customers that had sales in June but not in July.  =DISTINCTCOUNT(CustomerId_June),CustomerId_July=blank() Wh...
Need Help
veenashenolikar's avatar
veenashenolikar
Icon for Helper V rankHelper V
3 years ago

Hi That_Analyst ,

 

You could try creating a column with -

Flag = VAR firstid =
    FIRSTNONBLANK ( 'Table'[ID_June], "" )
VAR compare =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER ( ALL ( 'Table' ), 'Table'[ID_July] = firstid)
    )
RETURN
    IF ( ISBLANK ( compare ), 0, compare )
 
Then create a measure for count as -
Count = CALCULATE(DISTINCTCOUNT('Table'[ID_June]),FILTER('Table',[Flag]=1))
 
Hope this helps!
 
Regards,
Veena.