Percentage Based on Month Total

[Shell64]

Have data that uses table for Fin Yr and Fin Month joined to referrals table and need a pecentage breakdown per month

I have created a measure for referral count based on countrows  but can't get a measure to give me a fy/month breatdown.

Tried the below but doesnt work.

CALCULATE(

    COUNTROWS(Referrals),

    ALLEXCEPT(FinYr, FinYr[FinancialYear], FinYr[FinancialMonth])

)

2024-25	April	ReferralSource	11
2024-25	April	GP Referral	1
2024-25	April	Internal	4
2024-25	April	Other Provider	1
2024-25	April	Police	1
2024-25	April	Prison	1
2024-25	April	Probation Service	3
		ReferralSource	10
2024-25	May	Internal	5
2024-25	May	Other Provider	1
2024-25	May	Probation Service	4
		ReferralSource	9
2024-25	June	Internal	5
2024-25	June	Other Provider	1
2024-25	June	Prison	1
2024-25	June	Probation Service	2

[Shell64]

Thank you so much

[KNP]

Just realised when I pasted your data in that it had the totals in it.

Updated PBIX attached.

[KNP · Accepted solution]

Something like this should work.

(Use that calculation to work out percentage.)

Measure = 
    CALCULATE(
        SUM(Referrals[value]),
        ALL(Referrals[referrer])
    )

I've made some assumptions about column names and the model but this should help.

See attached PBIX.