Measure returning same value for all row

[BidyaSingha]

 For the below Dax i am getting same value for all status but expected o/p is different value. Can anyone help!

 CALCULATE(

    DISTINCTCOUNT(EmployeeAvailability[EmployeeCode]),

EmployeeAvailability[ShortTermBench]<>BLANK())

[mark_endicott · Accepted solution]

@BidyaSingha - This looks to be a relationship issue. Is the "Status" colomn in a separate table? If Yes, you need to create a relationship between EmployeeAvailability and the table containing "Status"

If No, and you only have one table then I would try: 

 CALCULATE(
    DISTINCTCOUNT(EmployeeAvailability[EmployeeCode]),
KEEPFILTERS( EmployeeAvailability[ShortTermBench]<>BLANK()))

If either of these work, please accept as the solution, if they do not, please share more information about your semantic model and perhaps some sample data.