Forum Discussion
Helper IIFinding the Most Repeated Date using Multiple Criteria
Super UserHi,
Share some data to work with and show the expected result.
Helper IIHi Ashish,
As you can see in the photo the graph above shows how many applications come in each day of the week, and the card is to show what date showed up the most (which as you can see in the pic is incorrect). The other card takes that date and gives a value of how many times it occured.
What I have found is that the code is taking the overall amount of times a date is showing up, rather than how many times it comes up based on another slicer. This is where the issue lies.
| Date | Regime |
| 01/01/2023 | AB |
| 01/01/2023 | CD |
| 05/02/2023 | AB |
| 01/01/2023 | AB |
| 05/01/2023 | CD |
| 05/01/2023 | CD |
| 01/01/2023 | AB |
| 06/05/2023 | CD |
| 01/01/2023 | AB |
As you can see from the table, 01/01/2023 would be the date that shows up the most, though the Regime it corresponds to isnt filtered. so AB would show 4 and when the slicer is changed to CD it would show 05/01/2023 appeared 2 times
Hopefully this makes sense
- Ashish_Mathur
Hi,
PBI file attached.
Hope this helps.