Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have an issue with two columns I am trying to subtract from.
One column is called Required Qty and the other is called Original Blanket Qty.
I created a measure called Unscheduled Blanket Qty:
Thank you.
Chad
Solved! Go to Solution.
pls try this
measure = max('Table'[orignial blanket qty])-max('Table'[rquired qty])
Measure 2 = sumx('Table',[measure])
Proud to be a Super User!
Hi @MP-iCONN
Your formula works well on my side, you can refer to my pbix file. If possible, please provide your pbix file so that we can find the cause of the problem .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
maybe you can try
SUM('Sales Orders'[Original Blanket Qty]) - SUM('Sales Orders'[Required Qty])
you can use measures to display the first two columns to check if returns the correct result and do the calculation between these two measures.
Proud to be a Super User!
Same issue.
I did a SUM measure for both Blanket Qty and Required Qty and then added in my Unchscheduled Blanket Qty with the SUM('Sales Orders'[Original Blanket Qty]) - SUM('Sales Orders'[Required Qty]) measure and still the same value where it is not subtracting the 1820 from 910 correctly.
pls try this
measure = max('Table'[orignial blanket qty])-max('Table'[rquired qty])
Measure 2 = sumx('Table',[measure])
Proud to be a Super User!
I tried this and the MAX seemed to work for measure1 (Unscheduled Blanket Qty) but then I did the SUMX of that Measure1 and still off.
Thank you for your help so far!
since i can't reproduct the issue, could you pls provide some sample data and expected output?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |