Forum Discussion

Rakesk13's avatar
Rakesk13
Helper III
3 months ago
Solved

How to get count from two different table

Hi team,   I need to Count  Emp Detail + Emp Summ i.e 8 + 5 =  13   I have data like this :    EMP Details     EMP ID  EMP NAME  AGE   AMT 1 A 1 1000 2 B ...
Need Help
  • jgeddes's avatar
    jgeddes
    3 months ago

    Here is one way to do this...

    Measure = 
var _distDet = 
DISTINCT(EMP_Details[EMP ID ])                  //unique Details Ids
var _distSumm = 
DISTINCT(EMP_Summ[EMP ID])                      //unique Summary Ids
var _commonIDs =
INTERSECT(_distDet, _distSumm)                  //unique Ids found in both tables
var _unqDet = 
COUNTROWS(_distDet) - COUNTROWS(_commonIDs)     //count of unique Details Ids not in common table
var _unqSumm =
COUNTROWS(_distSumm) - COUNTROWS(_commonIDs)    //count of unique Summary Ids not in common table
RETURN
_unqDet + _unqSumm
Ray_Minds's avatar
Ray_Minds
Solution Supplier
3 months ago

Solution:
You can simply create a the below measure to get that result.

Measure:

Total_Unmatched = COUNTROWS(EXCEPT(DISTINCT('EMP Details'[EMP ID]),DISTINCT('Emp Summ'[EMP ID]))) + COUNTROWS(EXCEPT(DISTINCT('Emp Summ'[EMP ID]),DISTINCT('EMP Details'[EMP ID])))

Result: