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:
% no-diff =
varbigTotal = countx(BI_Positionen_Orders,[Diff to Offer])
varZeroCount = countx(BI_Positionen_Orders,[Diff to Offer]=0)
Is it maybe better when I create a column "Diff to offer" instead of a measure?