Forum Discussion

gladies123's avatar
gladies123
Helper I
5 years ago
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 ...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    5 years ago

    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

v-luwang-msft's avatar
v-luwang-msft
Community Support
5 years ago

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