Single Landing Page Drillthrough Multiple Measures

[lherbert501]

Hi,

If I had multiple count measures e.g.

Website Sales

PhoneCall Sales

In Store Sales

Is there a way to drillthrough to the same generic destination page like in the example table below but carrying the count of each sales that is selected to the drillthrough, without including any of the measures  in the tablix?

Could this be done via calculation groups or anything similar?

I have more than 3 measures but I have used this as an example. I need a single landing page without carrying every single measure into the table

Thanks

sales id sales address sales date sales name sales item

[Akash_Varuna · Accepted solution]

Hi @lherbert501 Yes, you can achieve this using calculation groups in Power BI. Create a calculation group in Tabular Editor with items for each sales measure (Website Sales, PhoneCall Sales...). Use a generic field like "Sales Category" as a drill-through filter to dynamically pass the selected measure's context. This allows a single landing page to display the relevant data without including all measures in the table.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[lherbert501]

Hi @Akash_Varuna ,

Is there anyway you would be able to do a dummy pbix with this or a screenshot?

I thought I had it but I'm struggling to apply it

Thanks

Liam