Forum Discussion
Drill through based on Same Column Field
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 .
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.