Forum Discussion

Zaynah16's avatar
Zaynah16
Helper I
4 years ago
Solved

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 % ...
  • SpartaBI's avatar
    SpartaBI
    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

     

     

     

     





          

    Showcase Report – Contoso By SpartaBI