I have a table which is a record of request (total 33 request, 2 overdue). I add a column "Overdue" in data model to check if the request is overdue "Yes" or not overdue "No". I then create a measure to count the overdue request.
The measure gives me correct answer 2 overdue request, but when I click for drill down, it shows me the entire table. (not the correct 2 overdue request). How do I fix this to show only the 2 overdue request?