Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |