Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 :
When i use this measure TotalActivePortalUser it will return 6 but the expected result for my measure must be 5.
Any suggestions??? Many thanks!
Solved! Go to 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
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
It works! thank you so much!
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |