dax query to fetch filtered row

[Huzy001]

I have a power bi dashboard, the user can filter on account id, I need a dax query to return what the filtered account id is.
The account id is in a table however the account id could be repeated mutliple times.
I have tried evaluate row in dax however returns NULL. I need this dax query to work along side power automate.

[dharmendars007 · Accepted solution]

Hello @Huzy001 , 

You can use the below DAX code to show the filtered account ID

Filtered_AccountID = SELECTEDVALUE('YourTable'[AccountID])

If there are multiple account ID's are selected then please use the below code

Filtered_AccountID = CONCATENATEX(VALUES('YourTable'[AccountID]), 'YourTable'[AccountID], ", ")

If you're using Power Automate to pass the filtered result, ensure you are referencing the measure Filtered Account ID in the right context. Power Automate can extract this result via the Power BI connector.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Selva-Salimi]

hi @Huzy001 

what if two accountid is selected??

[Huzy001]

only one accountid can be selected at a time