Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
marcio_fornari
Resolver I
Resolver I

Measure to filter table only selected value

Hello, i need show into a table only data with Family is equal my Selected Value

 

My selected value Measure = SELECTEDVALUE(D_FAMILY[Family])

 

My table is 

D_EQUIP[n Equipamento] 

D_FAMILY[Family]

 

selectedvalue.png

 

it's Possible? Thanks

3 REPLIES 3
amitchandak
Super User
Super User

@marcio_fornari , The code you have given should work

 

or

My selected value Measure = max(D_FAMILY[Family])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi @amitchandak doens't work..

I record a video to help. 

 

i select the equipment on the map and the table shows me all the equipments that are of the same family, at this case are only 2 rows. 

After i need selected the equipment on the table to make a drill-through, but the table show others rows instead of keep the equipments. 

I don't want the table filter after click inside. 

If you look below the table, the selected value doesn't change, i was a think a measure to filter only rows equal family is my selected value

sorry my english is not very good, it's hard to explain this. 

 

Anyone can help me? 

 

I uploaded the example file: https://drive.google.com/file/d/1JDiLsIBYP9Un7l8Vvs89dLCkxl2WxN7p/view?usp=sharing

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.