Forum Discussion

BidyaSingha's avatar
BidyaSingha
Frequent Visitor
2 years ago
Solved

Measure returning same value for all row

 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]), EmployeeAvailabi...
  • mark_endicott's avatar
    mark_endicott
    2 years ago

    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. 

mark_endicott's avatar
mark_endicott
Super User
2 years ago

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.