topic how to return the selected value of slicer and add it as a field in summarize table in DAX Commands and Tips

how to return the selected value of slicer and add it as a field in summarize table

oakfootballclub — Mon, 08 Jul 2024 09:37:05 GMT

Hi experts,

I use selectedvalue but it fails to get the expected result.

for example,

ADDCOLUMNS(
SUMMARIZE('fact_tbl',
'fact_tbl'[week],
'fact_tbl'[gpn],
fact_tbl[base_currency],
fact_tbl[type],
"amount",CALCULATE(SUM('fact_tbl'[amount])0
)
,"selectedrk", SELECTEDVALUE(dim_topxslicer[col]))

it fails to get the expected result, do you know how to return selected slicer value in summarize and addcolumns function? Thank you.

Re: how to return the selected value of slicer and add it as a field in summarize table

foodd — Mon, 08 Jul 2024 09:57:02 GMT

Hello oakfootballclub , and thank you for sharing a question with the Community. Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Re: how to return the selected value of slicer and add it as a field in summarize table

BeaBF — Mon, 08 Jul 2024 12:41:54 GMT

oakfootballclub Hi! Can you paste some sample data?