Forum Discussion

Frequent Visitor

5 years ago

show a calculated table in a visual

There is a measure which shows the number of service contracts that fulfill a set of criteria: the date the contract started, the price plan it is in, the sales person responsible, etc. The measures ...

Need Help

Pragati11

Super User

5 years ago

Hi simormate ,

In Power BI drill-through works as follows:

Create 1st page which has got a table visual with all the summary elements.
Create a 2nd page which act as a Drill-through page from 1st Page when drilled in to details by drilling for example against a metric from the table visual on 1st page and then seeing it's details on 2nd page.

You can refer following blog on how drill-through works in Power BI to get an idea on how to visualise this functionality:

https://powerbi.tips/2018/09/drillthrough/

Thanks,

Pragati

simormate

Frequent Visitor

5 years ago

Yes, I knew this - the problem is that I would like to see individual records of a dataset after drilling through, and filtered not only with the filter context of the value that was right clicked, but also with the filters defined within the calculate function of the original measure.

Pragati11
Super User
5 years ago
Hi simormate ,

One way of doing this could be placing the FILTERS that are in CALCULATE function for this measure, under KEEP FILTERS section of drill-through page along with the field on which drill-through is created:

Thanks,

Pragati