Hi Mate,
Please help me on this, i am bit struck.
Lets assume i have table(Cust_fact) of 3 columns "year","Channel","Customer_id" and size of the table is 100 million
I wanted to show the table like below.
YEAR CHANNEL CUSTOMERCOUNT
2018 ONLINE 19999
2018 STORE 80000
2019 ONLINE 1M
2019 STORE 2M
I want to drillthrough and see who those customer are.
Approach i have done.
1. I get the table(cust_fact) in to powerbi in direct query mode.
2. In tranform editor created a reference table for it and named as cust_agg
3. Aggregated the cust_agg and changed the mode to import mode.
4. Created a drill through page i.e create a table and drag the customer_id from the main table (cust_Fact)
problem is could not see the option of drill through.
Do i need to create a relationship between aggregated table and the maintable ?
Any help is much appreciated.
