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]),
EmployeeAvailability[ShortTermBench]<>BLANK())

 

  • 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. 

1 Reply

  • 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.