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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.