Forum Discussion

vivran22's avatar
vivran22
Community Champion
6 years ago
Solved

Measure Help: Conditional Count

Dear Community Members,   Need your help in the following:   I have a dataset:   Task ID Timestamp Status ABC 2/2/2020 4:45 To-Do ABC 2/12/2020 23:52 Planned ABC 3/5/2020 16:...
DAX
Need Help
vivran22's avatar
vivran22
Community Champion
6 years ago

Hello Ashish_Mathur ,

 

Need your help in this:

 

Using the solution you had provided, I could create the following visual:

 

 

But when I am trying to replicate it on my orignal dataset, I am getting the error:

 

Not sure what is causing this. Please advise.

 

Sample pbix file

 

Cheers!
Vivek

https://www.vivran.in/
Connect on LinkedIn

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

It looks like for one Task ID there are multiple task owners.  That is causing a problem with the result of this measure - 

Status of last time stamp and of course the others measures which use this one as an input.
  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hello Ashish_Mathur ,

     

    It had worked well on the sample dataset but when I updated the records, I am not getting the required calculation.

     

    I checked for duplicate entries as advised by you but couldn’t find any. This is a tricky situation for me and I was hoping if you could provide more support on this:

     

    For simplicity, I have created two tables. What I am looking for is to create a visuals like the first segment:

     

     

    Sample pbix file

     

    Regards,

    Vivek