Forum Discussion
Zaynah16
4 years agoHelper I
Measure for Percentage difference
Hi everyone Please could someone help me with a measure I need to calculate the percentage difference between two status's ( on track = 1 and at risk = 2) Calculation Total number % ...
- 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