I Need help on Dax related to slicer filtering

[Heena_9980400]

Hi Experts,

I have a requirement where when I select product line id, the particular deal identifier will appear and for that particular deal identifier under recommendations the hardware will come, for that I require a dax.

Below find the screenshot attached.

Looking forward for suggestions, Thanks in advance.

Thanks & Regards,

Heena Kousar

[Anonymous · Accepted solution]

HI @Heena_9980400,

In fact, if these slicer source fields have relationships. These list of items will be filtered by table relationship and filter interactions when you chose item on these list.

Change how visuals interact in a report - Power BI | Microsoft Learn

If you want to achieve custom filter effect, you can break the relationship and use Dax formula directly extract selections and use in expression to return flag. After these steps, you can use this formula on ‘visual level filter’ to filter records.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng