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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Need help to fixe my matrice total (sumx ?)

I have a matrice:



 with some product name, reference line, stock quantity of the product, model stock of the product in different wharehouse, the gap between stock quantity and model stock, and the model stock covery

the dax code for the gap is : 

Abs(Case(([Stock Qty APAC] < [Model Stock APAC]); ([Stock Qty APAC] - [Model Stock APAC]); 0))

So in the total, there is a lot more of stock quantity than in model stock so there is no ecart at all, and i have a covery of 100%

How could i change my code for having a total which represents rows where the model stock is actually >of the stock quantity and where i have real stock covery ?

I'm desesperate with if for two days now, if someone can help me 🙂 

I tried to put 0 every time the stock quantity is > tothe model stock, but the problem is the same :

the calculation of the total is carried out at the level of the line so in this case, it is the stock model which is greater than the stock quantity and suddenly this one is displayed at 0, and I therefore have no difference

Super User
Super User

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
Please show the expected outcome based on the sample data you provided.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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


Power BI Monthly Update - May 2024

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


Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors