Struggling with Percentage of another total

[MatH]

Hi, I'm sorry but my mind is going completely blank and I think this should be quite simple.

I have a table which has a list of categories that are reasons why a caller has called us, a user can have more than one of these. I then have a measure which is Total Calls.

I want to be able to say each reason category was mentioned x% on total calls, and as people can have more than one reason these % should add up to more than 100%.

So I have a table like this:

Category	Count of Category
Reason A	100
Reason B	124
Reason C	104

So if we had 200 calls the % should be Reason A 50%, Reason B 62%, Reason C 52%.

I thought I should be able to do a query along the lines of Count of Category / Count of Calls. But this doesn't work, I'm wondering if it's because it's filtering my total calls measure?

Any help would be appreciated.

[Greg_Deckler · Accepted solution]

@MatH Try:

Measure =
  VAR __Caller = MAX('Table'[CallerID])
  VAR __Count = SUM('Table'[Count of Category])
  VAR __CountAll = SUMX(FILTER(ALL('Table', [CallerID] = __Caller), [Count of Category])
  VAR __Result = DIVIDE( __Count, __CountAll )
RETURN
  __Result