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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Juan_AL
Frequent Visitor

Measure to sum and hold information to filter when highlighted?

Hello everyone, is it possible to make a measure to hold information on the "backend"

example

i have this measure;

21-0 = CALCULATE(SUM('Inventory Focus Report'[21 - 0]))
which is part of this 100% stacked column
Screenshot 2023-03-16 145610.png

i want to tie it to a column from a table, that way when i click on the visual it will filter the other visuals.

is this possible?

the table where this is feeding from is tied this way


Screenshot 2023-03-16 145814.png


 

 

thanks beforehand

 
1 REPLY 1
lbendlin
Super User
Super User

 

i want to tie it to a column from a table

 

A measure cannot influence a column.  Your buckets would need to be stored in a column and that column be part of the data model in order to have a filtering effect on other related tables.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors