cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phteven79 Frequent Visitor
Frequent Visitor

Incorrect table totals based on a calculated measure

I'm looking at a table that has a top 10 of marketing publications that my company spend money on to advertise and track the phone numbers that each of them advertises. 

 

The data next to each publication in the table represents the rate of calls converted into quotes, the number of calls on that number that were answered and then the number of quotes given through that telephone number.

 

The totals at the bottom of the table for the number of calls answered and the number of quotes are fine but the total showing for the conversion rate of calls answered to quotes given makes no sense to me, I don't understand what it's calculating.

 

The top 10 conversion rates are;

 

  • 0.54
  • 0.29
  • 0.27
  • 0.26
  • 0.23
  • 0.2
  • 0.05
  • 0.04
  • 0.03
  • 0.02

The total of this comes out at 0.09 - I'm baffled!

 

The call to quote conversion rate is a measure made up of the following DAX query;

 

 

Call to Quote (exc Trans) = 
CALCULATE(
	SUM ( CTIPublication[Quotes]) / CALCULATE(
						  SUM(CTIPublication[Answered]) - SUM(CTIPublication[Transferred])
						  )
		  ,FILTER ( CTIPublication,[Answered] >= 50 )
		 )

 

As you can see I'm filtering out data where the number of calls answered from a particular phone number (publication) is less than 50. I'm guessing this is in some way interfering with the correct totalling of the conversion rate.

 

Any knowledge/suggestions would be hugely appreciated.

1 REPLY 1
Community Support Team
Community Support Team

Re: Incorrect table totals based on a calculated measure

 Hi @phteven79,

 

I think the cause is the context of the formula. The context of total is the whole source table if there aren't other filters. You can put this formula in a Card visual. You will find the result would be the same with it in the total. If you want to find more details, please provide a sample. The PBIX file would be great. 

 

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.