Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
this is my situation: I have a table with all the orders. I created a DAX measure to calculate the difference between order and the related offer. Now I want a DAX measure that tells me how many orders have no difference and how many orders have a difference to the offers.
I want to caclulcate the % of "no differences". Having it as a measure would enable me to see which salesman or which area etc has no differences and works maybe better etc.
So far I created this code but it didn't work:
Solved! Go to Solution.
Hi @Anonymous ,
Based on your description, I have created a simple sample:
Please try:
% no-diff =
var bigTotal = countx(BI_Positionen_Orders,[Diff to Offer])
var ZeroCount = countx(FILTER('BI_Positionen_Orders',[Diff to Offer]=0),[Diff to Offer])
return Divide(ZeroCount,bigTotal)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Based on your description, I have created a simple sample:
Please try:
% no-diff =
var bigTotal = countx(BI_Positionen_Orders,[Diff to Offer])
var ZeroCount = countx(FILTER('BI_Positionen_Orders',[Diff to Offer]=0),[Diff to Offer])
return Divide(ZeroCount,bigTotal)
Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
can you send some sample data of your source table and tell me how is written the measure [Diff to Offer]?
Hi @mangaus1111,
unfortunately the source data is all in german, so I don't know if that will help you and actually I don't know how to extract something there 😅
here is the code for Diff to Offer: [quantity]-sum(BI_Positionen_Orders[Qty predecessor document])
User | Count |
---|---|
140 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |