Forum Discussion
Finding the Most Repeated Date using Multiple Criteria
Hey thank you for your response!
Unfortunately this does not bring up what I am trying to achieve. I have found that I am needing to update the Max Date Count measure so ensure that the correct date is shown based off the Regime slicer - any thoughts?
Hi,
Share some data to work with and show the expected result.
Hi 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
Hi,
PBI file attached.
Hope this helps.