Measure for Percentage difference

Zaynah16 I'm not sure what do you mean by 'percentage total score' 🙂
Anyway I took a guess, maybe this will anyway show you the way:

_Measure = 
VAR _pct_on_track = 
DIVIDE(
	CALCULATE(
		SUM(RAG status[Score]),
		RAG status[Status] = "On Track"
	),
	CALCULATE(
		SUM(RAG status[Score]),
		REMOVEFILTERS(RAG status[Status])
	)
)
VAR _pct_at_risk = 
	DIVIDE(
		CALCULATE(
			SUM(RAG status[Score]),
			RAG status[Status] = "At Risk"
		),
		CALCULATE(
			SUM(RAG status[Score]),
			REMOVEFILTERS(RAG status[Status])
		)
	)
RETURN
	_pct_on_track - _pct_at_risk

In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.

SpartaBI Logo

Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

Showcase Report – Contoso By SpartaBI