Average for each small multiple

Got it — since you're using Patient Name (a text column) on the Y-axis, you're likely trying to count the number of patients per month per location, right?

In that case, you can’t use SUM, but you can definitely use COUNTROWS or DISTINCTCOUNT depending on what you want to measure.

Here’s a DAX measure you can try:

Monthly Patient Count = 
CALCULATE(
    COUNTROWS(FinalTable),
    ALLEXCEPT(FinalTable, FinalTable[Month], FinalTable[Location])
)

Or, if you want to count unique patients:

Monthly Unique Patients = 
CALCULATE(
    DISTINCTCOUNT(FinalTable[Patient Name]),
    ALLEXCEPT(FinalTable, FinalTable[Month], FinalTable[Location])
)

Then use this measure on the Y-axis, with:

• X-axis: Calendar[Month]
• Small multiples: FinalTable[Location]

This will give you the monthly patient count per location, which is what I think you're aiming for.

Also, here’s a helpful doc on small multiples in Power BI:
🔗 https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-small-multiples

Let me know if you want to calculate averages instead of counts — happy to help with that too.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.