Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Cumulative Totals Chart Filtering Issue

Hi,   I have a fun challenge I've been working on for the last week or so and it's got me stumped.   Here's my data set:   Project # Job # Date Count Category 1 1 1/1/2022 5 Red ...
Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    That might be trickier, it depends on how you define "top date". It might work for either earliest or latest dates, I'm not sure. Another option would be to define another measure which ranked it appropriately and use that in the topn filter

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for the repsonse, John. If I'm not wanting the Top Count and only wanting the count associated with the Top date for each Project (within the filter context), should I do TOPN based on the date instead? Or are you thinking based on the count?

johnt75's avatar
johnt75
Super User
4 years ago

That might be trickier, it depends on how you define "top date". It might work for either earliest or latest dates, I'm not sure. Another option would be to define another measure which ranked it appropriately and use that in the topn filter

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ya, I've gone that route before and the performance was horrible. But it was probably due to my janky DAX. I'll try that route again if the visual level filters aren't working like I want.

     

    Thanks for the input.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Any thoughts on how I could set up this measure?