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
SebSchoon1
Post Patron
Post Patron

DAX total value can't find the right context in formula

Hi fellows,

 

I'm struggling with a measure in Dax

here my model

 

SebSchoon1_0-1662538806176.png

The circled table is a summarized table obtained with this formula

Articles en stock par ref = SUMMARIZE('Stock Dispo full','Base art finale'[CODE ARTICLE],"Total par réf art",sum('Stock Dispo full'[QUANTITE PHYSIQUE]))
 
Wich givez me the right results ( Aggregated quantities By CODE ARTICLE (Item ref) By Warehouse (in Dépots et établissements ==> [CODE DEPOT]
 
However,
 
when i drop this formula in my measure i also receive all the Data in non concerned Warehouses.
 
SebSchoon1_1-1662539025828.png

I would like not showing the not concerned warehouses

 

How can i do that? 

 

 

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi. @SebSchoon1 

Not fully sure what you want.

If you just don't want to show blank sections, try applying filter criteria in visual filter pane to filter the data.

Best Regards,
Community Support Team _ Eason

SebSchoon1
Post Patron
Post Patron

I add that if i use the resulted value From the summarized Table in my pivot table view, 

 

it shows me the right information,  i'll just need to use these data to compute some calculations in other summarized tables.

 

Like % of total values and so on so i need to have measures on it

 

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
Top Kudoed Authors