Calculated measure in Pivot Table

Hi!

I´ve been trying to get a measure in my pivot table to get the % of reject orders of a partner / Total order order of partner, and that it can change if I use a slicer to change it by day, month, etc.

This is an example of the data table which I use:

1623629878531.png

And this is the pivot table which I have created:

1623629917661.png

I would like to calculate the Percentage of Rejected message type of the Partners (fail rate owner Partner) / Total orders of the Partner(this would be the total of rejected messages which from all type of fail rate owner), and that the measure could change if a filter the data by date or which whatever I filter it.

I can do it with countifs but i need to get this percentage in the Pivot table.

For example: in high demand por partner 1, it only has 1 count, but the total orders for this Partner are 7, the percentage would be: 1/7 = 14%


I attached the example file and I would be very grateful if anyone could help me.

thanks!

Originally Posted by rorya

Should the total count change to reflect your slicers, or should it always be the total for that partner?

The total should reflect the total count of my slicers, but Iin this case I need that the total changed by date, if I filter any day it should give me like this: (total orders with fail raite owner Partner of each Partner I have in my rows)/(total order with all fail rates owner of each Partner in my rows) and the denominator has to be the one that has to change when I use any filter, slicer or change the date, because the numerator is the count that gives me the pivot table without any complex calculation

Originally Posted by rorya

So to clarify: both numbers should be filtered by whatever slicer value you select? For example, filtering for June would produce a ratio of 1/6 for high demand partner 1?

Exactly they should be filtered whatever slicer value I select,The correct in high demand ratio would be 1/7 it has to be the (partner failrate owner of that reject message from Partner 1 of June)/ (total orders of June for partner 1(taking on count all the failrate owners))

Originally Posted by rorya

There are only 6 June entries for partner 1, not 7. So should it be 1/6 or should the denominator ignore the month filter?

Sorry! My bad, you are completely right, it should be the way you explained before, 1/6

But I need that this measure, works with other filters like week or day

It´s quitely like that, but the ratio doesn´t gives me the 1/6 in the partner 1 high demand.

Could you please help me out with this arrangement and share me the measure?

Ill thankyou a lot.

Thats exactly what I needed. Thank you so much!!