Forum Discussion
vivran22
6 years agoCommunity Champion
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:...
- 6 years ago
Ashish_Mathur
6 years agoSuper User
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
6 years agoCommunity Champion
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:
Regards,
Vivek