Drill through based on Same Column Field

[Anonymous]

Hi everyone, Can you please help with following scenario?


Let's say you have a table with agreement ID, Agreement Value. In main report, when we drill through on Agreement ID the drill through report in other page should have list of Agreement IDs having lower Agreement Value compared to the selected Agreement ID .

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create slicer by Agreement ID column and a measure that satisfies the conditions.

slicer = VALUES('Table'[Agreement ID])

Lower Value Flag =
IF (
    MAX ( 'Table'[Agreement ID] ) < SELECTEDVALUE ( slicer[Agreement ID] ),
    TRUE,
    FALSE
)

create slicer in drill page

Right click on the selected id to drill down. It will jump to the des page and show the results that fulfill the conditions.

For more details, you can read below document:

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

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