Forum Discussion

Hussein_charif's avatar
11 months ago
Solved

Drill Through on multiple measures

Hello,   i have multiple measures that have filters on them to show me the values i need, for examples revenues, cost of sales, gross profit, etc...   i have a table that has the name if those me...
  • Ritaf1983's avatar
    11 months ago

    Hi Hussein_charif 

    You can drillthrough from any visual, even if the displayed value comes from a measure.
    However, the drillthrough always uses the exact filter context coming from the source visual — it cannot switch, adjust, or reinterpret the context based on a different measure or a different business rule.

    In other words:

    Drillthrough does not pass the measure, it passes the filter context that produced the value you clicked.

    The target page will always show the exact same context, recalculated there.

    If you expect different detail rows for different measures (e.g. different account sets), this is not a drillthrough feature, it requires a field in the data model that distinguishes the logic (e.g. Account Group, KPI Type, Category, etc.).

    Without such a field, Power BI cannot identify which detail logic belongs to each measure, because drillthrough is strictly context-based and source-visual driven.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly