Drillthrough Help

[lherbert501]

Hi there,

In the below example, Is there a way to drillthrough on the homepage below from either of the two measures, to the destination page to show the sales ID's that are applicable?

I can't show the measures on the destination tablix, just the id's. I don't think this is possible without showing the measure on the destination page or a tab for each measure filtered, but I just wanted to clarify. PBIX link is below.

Is there a way around it somehow? Also, I have 15+ measures on my home page, all with different measures against different fields on my actual version.

Drillthrough.pbix

A) Home Page

B) Destination Page

Thanks

[Anonymous · Accepted solution]

Hi @lherbert501 ,
Thank you @SamWiseOwl  for the helpful response!
Since Power BI doesn’t currently support measure-level drillthrough cleanly when multiple measures are used on the same visual. I recommend posting  this idea in the Power BI Ideas forum. That way, the product team may consider adding support for drillthrough based on individual measures without needing a workaround.

Hope this helps.If so,give us kudos and consider accepting it as solution.

Thank you

Regards,
Pallavi.

[lherbert501]

Hi @Anonymous ,

Understood, thankyou for your response.

Thanks

Liam

[SamWiseOwl]

Hi @lherbert501 

You could create a second measure to use on the drillthrough page:

Hide Category Sales = If( CALCULATE(COUNT(Sales[Salesid]),Sales[category] = "IT"), " ", BLANK())

Set the visual column aliase to a space and the column is effecitvely hidden:

Or set it in the Filter Pane as a visual level filter that returns not blank.

Then set this filter to hidden using the eye ball:

[lherbert501]

Hi @SamWiseOwl 

Thanks for this. 

Would this still work with e.g. 15 measures?

Thanks

Liam

[SamWiseOwl]

I don't see why it wouldn't.

[lherbert501]

Hi @SamWiseOwl 

I have just tested on a second measure which was just simply total entries and its contradicted the first measure already and just showing the first measure as its the filter.

Don't think this one will work. Looks like it will have to be a bookmarks job unfortunately.

Thanks

Liam

[lherbert501]

@SamWiseOwl 

I was just thinking if one of the filters happened to condradict another

Thanks