How to calculate Total distinct row with no blank

[Anonymous]

Hello all,

I have a table which has value on column PortalUserId (see image below). I need to calculate the total PortalUserID with status Active and  without the blank rows.

My current DAX formule is :

1.  TotalActivePortalUser = CALCULATE([TotalPortalUserID], 'Fact user license New'[Status] = "Active"). 
2. The TotalPortalUserId is also a measure, which is TotalPortalUserID = DISTINCTCOUNT('Fact user license New'[PortalUserID]).

When i use this measure TotalActivePortalUser  it will return 6 but the expected result for my measure must be 5.

Any suggestions??? Many thanks!

[msornakumar · Accepted solution]

Hi ,

 Can you please try the below formula

TotalActivePortalUser = CALCULATE([TotalPortalUserID], 'Fact user license New'[Status] = "Active" , NOT ISBLANK('Fact user license New'[PortalUserID]) )

Thanks

Sorna

[Anonymous]

It works! thank you so much!