Measure returning same value for all row

BidyaSingha — Tue, 21 May 2024 09:25:38 GMT

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())

Re: Measure returning same value for all row

mark_endicott — Tue, 21 May 2024 09:43:06 GMT

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.

topic Measure returning same value for all row in DAX Commands and Tips

Measure returning same value for all row

Re: Measure returning same value for all row