Forum Discussion
Solved
Reg:Active Count and Inactive Count
Hi Team,
Kindly provide the solution for the following issue, i have A Table and B Table. A Table contains id, name ,salary date, B table has the same as table A conatains , So i would like to have an output as shown in the image , Hereby i have attached an image for your reference.
Thanks,
Gladis
Hi gladies123 ，
Use the following dax create measure:
TOTAL = COUNT(A[A ID])ACT = COUNTROWS(FILTER('A',CONTAINS('B',[ID],'A'[A ID])))INACT = COUNT(A[A ID])-COUNTROWS(FILTER('A',CONTAINS('B',[ID],'A'[A ID])))Final get :
Wish it is helpful for you!
Best Regards
Lucien
1 Reply
Hi gladies123 ，
Use the following dax create measure:
TOTAL = COUNT(A[A ID])ACT = COUNTROWS(FILTER('A',CONTAINS('B',[ID],'A'[A ID])))INACT = COUNT(A[A ID])-COUNTROWS(FILTER('A',CONTAINS('B',[ID],'A'[A ID])))Final get :
Wish it is helpful for you!
Best Regards
Lucien