Reg:Active Count and Inactive Count

[gladies123]

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

[v-luwang-msft · Accepted solution]

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