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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
tnwcloud
Regular Visitor

Calculating a value at a higher grain that responds to a lower grain filter

Given a simple geographic hierarchy like Region>Country>Metro, I need to calculate a SUM at the Region grain that responds to a filter passed from a slicer at the Metro grain.

 

In a matrix I can create a measure [Regional Sales] = CALCULATE ( SUM ('BFT'[Sales],ALLEXCEPT('BFT','BFT'[Region])) and as long as Region is on the Rows before Metro it will display the total Region Sales for each Metro.

 

But what I want is a measure that will display the correct value for Region Sales if only Metro is on the matrix, or if the measure is put on a Card and a Metro is chosen in a slicer.

 

My real world case is more complex but if I can figure out this simple example I think I'll be ok. I guess you can't do attachments anymore so here's an image I hope clarifies what I'm looking for:

RegionExpression.jpg

 

 

 

1 REPLY 1
wdx223_Daniel
Super User
Super User

calculate([$ sales],allselected(BFT))

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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