custom drill-down issue (returns 1 row instead of 28 rows)

[lauwrie]

Hi All,

I have a question concerning a 'custom' drill down I'd like to create.

I created some columns with a count how often a certain address is used, or a certain VAT number, etc.

Eg, we have the address "Rue des bouchers 78, 1000, Brussel" and it exists 28 times in the dataset.

The (calc) column 'cCountAddress' shows on all 28 lines the number '28'. In another column, I have a calculated primary key.

In the same row we have 'cCountPhone' with the number '14' because the exact phone number exists in 13 other contacts / rows.

Because of the, I guess row context, when drilled through the details page only shows one row of data.

I'd like to see the 28 rows.

Depending on the count I start from: Address, VATnumber, Name, etc.

It will be more clear when looking at the screenshots.

Unfortunately, we are not the owners of the data(set), so I cannot disclose the pbix file. 

If it's not feasible to accomplish in a single drill-down,
There are six categories of cCounts; in the worst-case scenario, I may need to create six separate detailed pages (individual drill-downs).

Many thanks in advance for all advice.

[amitchandak]

@lauwrie , Based on what I got so far, Your drill through the report is missing a group by or not summarized column, like email or address. That is needed to show the rows.

if needed add an index or rank column to your table and add that to visual

Power Query- Index Column: https://youtu.be/NS4esnCDqVw

Power BI and Power Query- Sub Category Rank and Index: https://youtu.be/tMBviW4-s4A

Column Rank: https://www.youtube.com/watch?v=wDS_Vi4r9I4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=39