Retrieve more data based to result of a measure (number data type)

[Ait-james]

Hello community,

I would like to know please if it's possible to do these two things in Power BI.

Case 1 : How can retrieve the information of the 2 orders based to the result of the measure I created ?

Example of scenario -> When I click on the number "2" I will be redirected to another page who contain a table that will be populated with order information.

Case 2 : Display the order with high priority among the 2 orders.

Thank you !

[v-yangliu-msft · Accepted solution]

Hi  @Ait-james ,

Do you consider syncing slicers.

I created some data:

Index table：

Order table：

Here are the steps you can follow：

1. In Page1, use [Index] as the slicer, and click View – Sync slicers.

The same slicer will also appear in Page2 later, and the two slicers will communicate with each other

2. Create measure.

Flag =
var _select=SELECTEDVALUE('Index table'[Index])
return
IF(
    MAX('Order table'[priority])<=_select,1,0)

3. Place Measure[Flag] in the Filter in Page2, set is =1, and apply filter.

4. Result:

When the click slicer in Page1 is 2, it will be synchronized to Page2, and the information of priority<=2 will be displayed.

Best Regards,

Liu Yang

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

[selimovd]

Hey @Ait-james ,

that should be possible with a drill through button:

Create a drillthrough button in Power BI - Power BI | Microsoft Docs

https://www.youtube.com/watch?v=4Qy-bksqExI

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic