cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Yossi16
Regular Visitor

SELECTEDVALUE Question

Hello,

Is it possible to return a table with the filter of the SELECTEDVALUE function? I tried to do it with a calculated table, but it won't let me. Additionally, I attempted to use a measure, but I encountered a scalar error that prevented me from achieving the desired result.

What would you suggest as my best option?

 

Something like that... 

Peers_industry = FILTER( DWH_Lookup_Companies, DWH_Lookup_Companies[Industry] = SELECTEDVALUE(DWH_Lookup_Companies[Industry]) )

 

Thanks..

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Yossi16 

I guess what you want to achieve is when you select either Roni or Sami the table will be filtered down to only both rows because they both share the same School. 
There are a number of methods to accomplish this however none of them can be a calculated table as calculated tables/columns do not interact with the filter context. Therefore, I would suggest to simply have a disconnected table of the names. The you can create a filter measure that you can place in the filter pane of the table visual and  select "is" 1 then apply the filter

FilterMeasure =
INT (
SELECTEDVALUE ( 'Table'[School] )
IN CALCULATETABLE (
VALUES ( 'Table'[Scoop] ),
'Table'[Name] IN VALUES ( Names[Name] ),
ALLSELECTED ()
)
)

View solution in original post

5 REPLIES 5
tamerj1
Super User
Super User

Hi @Yossi16 

I guess what you want to achieve is when you select either Roni or Sami the table will be filtered down to only both rows because they both share the same School. 
There are a number of methods to accomplish this however none of them can be a calculated table as calculated tables/columns do not interact with the filter context. Therefore, I would suggest to simply have a disconnected table of the names. The you can create a filter measure that you can place in the filter pane of the table visual and  select "is" 1 then apply the filter

FilterMeasure =
INT (
SELECTEDVALUE ( 'Table'[School] )
IN CALCULATETABLE (
VALUES ( 'Table'[Scoop] ),
'Table'[Name] IN VALUES ( Names[Name] ),
ALLSELECTED ()
)
)

Great! Thank you.

It's not clear what you are trying to do. Is peers_industry supposed to be a measure, a calc colum, or a new table?  The DAX you have written is a table function, so it can only be used by creating a "new table". Measures and columns must return scalar values, not tables. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Alright, I will try to explain myself better:

I have a slicer that selects a specific value from a table. My goal is to retrieve another value from the same row as the selected value and use it as a filter in a Matrix visual. This way, the Matrix will display a table with only the data that matches this specific filter.

For example, if the selected value in the table is "Dan," I want to filter the Matrix to display only data related to "UCLA."

I hope this clarification helps. 

Yossi16_0-1686465685482.png

 

 

Thank you

It sounds like you do not have a dimensional model. I could be wrong. Read my article here. https://exceleratorbi.com.au/the-optimal-shape-for-power-pivot-data/

if you have a dimensional model, this type of filtering behaviour happens automatically. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors