The goal is to setup a drill through filter on the table for the page Expenditure that will do the following:
There are two pages Expenditure and Thorough Table in the Pbix file.
Example: When we right click on January Months Amount (50) for Expenditure Description Food -> Drill through -> Thorough Table
In the thorough table it should only display January month’s (selected month’s) data not all the months Expenditure.
Note: The scenario shown here is just for example purpose. We cannot use the month column for the table, we must use measures and need to do the drill through filter to display the individual values that compose the result of the measure.
Pbix File : https://drive.google.com/file/d/1vJ5gc5kTFXKb0Yup95gApyZus2_I2Mt8/view
Expected Output :