Sum of counts for each category with % total

[brettgrubbs]

I have tried many different suggestions from this forum allselected, allexcept, summarize as a new table and everything I just cannot figure this out. I need a total count for each provider to calculate the percent of each subcategory. I have the following table and if I can get it to work then I can put it on the visual to compare the % totals rather than counts. I have a page that can be filtered by year, month, and provider(s) . I need the total and % for each provider based on the selections in the filters. 

Here are the two measures as I have it now since this was the closest I have gotten. 

Here is a link to a greatly reduced excel file that shows on the first tab what I want to see and the 600 rows with what I think are the minimum columns need for this visual. The date column is linked to a date table and the provider ID is linked to a provider table but I just included the provider as a column to make it easier. The slicers on the below page are of course using the date and provider tables to filter.    

Total CPT Count by Provider = CALCULATE(Count(CPTsByEncounterAndClaim[Encounter ID]),ALLSELECTED(CPTsByEncounterAndClaim[Encounter ID]))

% Total CPT by Provider = DIVIDE(Count(CPTsByEncounterAndClaim[Encounter ID]),CPTsByEncounterAndClaim[Total CPT Count by Provider],0)

corrections shown in orange and red

[amitchandak · Accepted solution]

@brettgrubbs , Change the total like

Total CPT Count by Provider = CALCULATE(Count(CPTsByEncounterAndClaim[Encounter ID]),Filter(ALLSELECTED(CPTsByEncounterAndClaim),CPTsByEncounterAndClaim[Provider] = max(,CPTsByEncounterAndClaim[Provider])))

[brettgrubbs]

Thanks, It works great but I don't quite follow the logic... basically you changed it to filter the "ALLSELECTED" CPTsByEncounterAndClaim table which should be 600 rows by the provider... but I don't understand how "MAX" works in this filter when I have more than one provider selected... wouldn't it just return "RRO"?