Drill through based on Same Column Field

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.