Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
User | Count |
---|---|
9 | |
8 | |
6 | |
6 | |
6 |