Forum Discussion

Krushnab85's avatar
Krushnab85
Icon for Helper I rankHelper I
1 year ago
Solved

Need a help with dax

I have two tables - Table 1 is Dimension which shows HCP Id with affiliated Center IDs  Center ID HCP ID A 21 B 22 C 23 C 24 C 25 B 26 Table 2 Fact Table - Shows HCP...
Need Help
Show and Tell
Tips and Tricks
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Krushnab85 First create a relationship between the two tables based on the Center ID column.

     

    Reach Count =
    VAR DimHCPs = VALUES('Table1'[HCP ID])
    VAR FactHCPs = VALUES('Table2'[HCP ID])
    RETURN
    COUNTROWS(
    INTERSECT(DimHCPs, FactHCPs)
    )

anmolmalviya05's avatar
anmolmalviya05
Icon for Super User rankSuper User
1 year ago

Hi Krushnab85, Please try the below measure:

Reach Count =
CALCULATE(
COUNTROWS(Table1),
FILTER(
Table1,
Table1[HCP ID] IN VALUES(Table2[HCP ID])
)
)