Forum Discussion
Measure for Percentage difference
- 4 years ago
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
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
Thank you! This worked!
- SpartaBI4 years agoCommunity Champion
Zaynah16 my pleasure 🙂 Will appreciate your Kudos 🙂
P.S. check out my showcase report - got some high level stuff there 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂- Zaynah164 years agoHelper I
Hi SpartaBI
Another quiestion please
I've got a graph with the above data however when i click on the No data or lagging on the grapgh it gives me a percentage. How do i exclude lagging and no data and only have a result when clicking on the on track or at risk. if possible could we have it return N/A when clicking on the no data and lagging