Hi, I have a weird issue.
I have a # of filters on my report that work great. No issues at all. All except Date Buckets
I have a field on SQL Load that shows datebucket (integer) = 1,2 or 3, each being based on a date range
(1 <1 day, 2 1-3 days, 3 > 3days.
So every record will have a value of 1,2 or 3
I load this table into the report, then have the above as a bar chart. I then want to click on each bar and depending on the bar clicked, only show records that match the clicked bar.
Kind of thought this would be a no brainer. I was wrong.
No matter which bar you click on, the records show all, completely ignoring what was clicked (EX. clicking on th green bar should show a filtered dataset of 228 records.
Each of the three buckets above are measures, built the following way
<1 Bus. Days = CALCULATE( DISTINCTCOUNT( Main[id]), Filter(Main,Main[Bus Days Buckets]=1))
<1 - 3= CALCULATE( DISTINCTCOUNT( Main[id]), Filter(Main,Main[Bus Days Buckets]=2))
<1 - 3= CALCULATE( DISTINCTCOUNT( Main[id]), Filter(Main,Main[Bus Days Buckets]=3))
The filtering fails.
Any help would be extremely appreciated. I'm spending my labor day weekend trying to figure this out and I just ran out of ideas.