Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'd like to ask for help please.
I have a table table1 which contains "Sprint name" column and is used in slicer.
I have another table table2 which is summarized/filter from table1. I want to use the selectedvalue from slicer to be able to filter my table2 but with a different value:
filter(table2, table2[index] <= (select index from table2 where [table2]sprintname = selectedvalue(table1[sprintname]))
I'm not certain how to do the one in bold. When i create a var as part of table2 query:
var sprintName = selectedvalue(table1[sprintname]) <- this one doesnt seem to pick up any value
but when i create a measure under table2, i am able to get the selectedvalue but i'm not able to access it as filter in the table2 query (where measure was created).
Thanks so much!
Have you tried just =, instead of <=? The SelectedValue is a text value, right?
--Nate
Hi! Unfortnulately, no that doesn't work.
I wanted to filter may table2 based on the selected value from slicer in table1
If I hard code sprint name below it works:
Hi @Anonymous ,
Currently it is not supported to pass selected slicer values to a calculated table in Power BI, use selectedvalue() would return all blank value.
If write like calculate(max('Table'[Name]),allselected('Table')), it would return the max name value from the table.
You have need to make hard code for the calculated table to filter it.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
40 | |
26 | |
22 | |
21 | |
16 |