% of with count & measure

[DinEileen]

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:

% no-diff =

var bigTotal = countx(BI_Positionen_Orders,[Diff to Offer])

var ZeroCount = countx(BI_Positionen_Orders,[Diff to Offer]=0)

return Divide(ZeroCount,bigTotal)

Is it maybe better when I create a column "Diff to offer" instead of a measure?

Thanks and all the best 🙂

[v-jianboli-msft · Accepted solution]

Hi @DinEileen ,

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.

[mangaus1111]

Hi @DinEileen ,

can you send some sample data of your source table and tell me how is written the measure [Diff to Offer]?

[DinEileen]

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])