I am trying to build my first drill through report in Power BI.
My tables look like this :
The data model looks like this:
The table in the first report looks like this:
This report has slicers and text filters that filter on "Region", "Product Description" and "Number of Products".
Upon filtering using slicers, now I am clicking on a row in a table to drill though and opening another report - sub-product report.
When I create a card in the sub-product report for "Region", I get options like, "First", "Last", "Count" etc. First and Last of which set of rows is what I am trying to understand.
The combination of "Region" and "Product Name" given by the column REGION_PNAME is unique. When I filter using the slicers, say it results in 10 rows in the first product report. But I am however drilling through on one row only. Is the drill through solely based on the value of "PNAME" (Product Name) or other values of the row are taken into account ? Because it is possible that a particular product, say P1 can belong to both Region "A" and Region "B" and choosing FIRST_REGION would be incorrect. I want to be able to see just 1 Region Value which belongs to Region - Product combination row on which I drilled through.
I am trying to understand what flows into the second report from the first report when I drill though. I am keeping the filters across reports. In my second report the drill though is "PNAME" (Product Name).