Forum Discussion
Drillthrough filter
See what you make of this:
Drill Through Example
You were making life hard for yourself and slowing power bi down by converting your dates to text strings to join on. I think you may have something odd coming in from power query so go into it and make sure column types are set as Date not datetime.I then improved your date table and was able to tidy your filter logic.
Finally there is then a visual filter set on the drill through table equal to 1
If you're unsure of anything I've done please reply and can help.
Community ChampionSee what you make of this:
Drill Through Example
You were making life hard for yourself and slowing power bi down by converting your dates to text strings to join on. I think you may have something odd coming in from power query so go into it and make sure column types are set as Date not datetime.
I then improved your date table and was able to tidy your filter logic.
Finally there is then a visual filter set on the drill through table equal to 1
If you're unsure of anything I've done please reply and can help.
- AlexisOlson
Super User
Instead of defining a new measure, I think you could get an equivalent result by setting the measure filter [Count Id] is not blank.
This won't make the drill-through show the prior month too (as OP wants) but adding [Count Id] to the detail visual could fix that (and remove the need to have it as a measure filter).
sorry since i just made a sample file that why dates was still text there.and that visual filter on drill through actually has a purpose .if you open that caluclated column you will see its giving a 1 or value based on created ts qnd updated ts and since that same filter was used in count measure it is needed in drillthrough as well.
but still how can i create that measure which was the main question i had
