Forum Discussion
Filter date table using measure
I have an issue with a KPI report I have. The report shows KPI for our it tickets for example if the Breached response or if they where fixed first time. The report has number of KPI per page and ...
I'm not sure I understand. I don't want to create a new table but in some way filter the date table I have to just show required date range. Ie
IF ISFILTERED(IV_dim_CALENDAR_ResolvedDate[YearMonthShort]) , filter the table to that year\month, filter to year\month where IV_dim_CALENDAR_ResolvedDate[Is Current Month] = "True"
Then be able to put that onto each of the required visuals as a filter
If this cannot be done then I need away to pass through the date to the drill through page. Initially the measures check if is filtered then dose a calculation. If it is not filtered then it does a calculation based on those rows in date table which have column [is current month] = "true". However the [is current month] value is not filtering the drill through page
Then be able to put that onto each of the required visuals as a filter
If this cannot be done then I need away to pass through the date to the drill through page. Initially the measures check if is filtered then dose a calculation. If it is not filtered then it does a calculation based on those rows in date table which have column [is current month] = "true". However the [is current month] value is not filtering the drill through page