Calculating Delay Rate with Slicers

Question

Hi all,&nbsp;I am fairly new to DAX and am a bit stuck on something, I have tried googling/lurking for a solution to no avail.&nbsp;I'm trying to calculate the delay rate of delivery trucks.&nbsp;I have a table with one row for each&nbsp;delivery, it also includes a column with the delay code. The measure "Delay Rate %" is being used as the values for a column chart with a month axis.&nbsp;It works perfectly when I specify the reason&nbsp;in the measure (example):Delay Rate % = CALCULATE(SUM(Data[Delivery Complete),Data[Delay Reason]="WEATHER")/SUM(Data[Delivery Complete])However, I would like the user to be able to select&nbsp;the delay reason from a slicer. (e.g. weather, fuel, customer, traffic, etc)&nbsp;What would be the easiest way to do this? (if&nbsp;at all possible)&nbsp;Thank you for your help in advance.&nbsp;:smileyhappy:

mattallington · Accepted Answer

Get rid of the calculate all together and just keep the division. Add a slicer on your delay reason column, and it will work (after you add the extra calculate below). &nbsp;Calculate is a hard coded way to apply a filter. A slicer is another way to apply a filter, but it is user selectable&nbsp;you will need to add a new calculate to the denominator so it ignores the slicer.&nbsp;&nbsp;Denominator should be&nbsp;calculate(sum(data[delivery complete]),all(data[delay reason]))

Forum Discussion

2 Replies

Related content