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
jgeddes's avatar
jgeddes
Super User
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
  • Rakesk13's avatar
    Rakesk13
    Helper III
    3 months ago

    Really thanks !!! its help me out.

     

    Thanks !!!