Vishal P on 24 Nov 2020 11:31:01
Scenario: Suppose I have a Matrix Visual with columns as "Week","Month","QTR", "Year" and "Last Year" and rows as an Assigned field which has names of assigned persons. Here I am trying to get the count of tickets which the assigned person has resolved for a week, month, QTR, Year, and Last Year which is nothing but the names of the columns.
Below are the measures using which I get the numbers:
1. Week = CALCULATE(COUNT(TicketsStaging[assigned]),
FILTER(TicketsStaging,TicketsStaging[Week]=WEEKNUM(TODAY(),2)),
FILTER(TicketsStaging,TicketsStaging[Year]=YEAR(TODAY())))
2. Month = CALCULATE(COUNT(TicketsStaging[assigned]),
FILTER(TicketsStaging,TicketsStaging[Month]=MONTH(TODAY())),
FILTER(TicketsStaging,TicketsStaging[Year]=YEAR(TODAY())))
similarly for other columns.
After doing all this I get values for assigned based on the columns. Now the issue arises when I try to implement Drill Through by clicking on one of the numbers inside the matrix visual the filters and drill through to the detailed page I get the total number of records for that full row and not the number which I have clicked to drill through. This means the filters applied inside the measure are not carried to the next page.
Regards,
Vishal