Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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 , Change the total like
Total CPT Count by Provider = CALCULATE(Count(CPTsByEncounterAndClaim[Encounter ID]),Filter(ALLSELECTED(CPTsByEncounterAndClaim),CPTsByEncounterAndClaim[Provider] = max(,CPTsByEncounterAndClaim[Provider])))
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"?