Sum of Measure outputs in table

[StidifordN]

Is it possible to sum together the outputs of a measure?

I have a table popualted with measures (image below), and conditionally formatted (Red = 50, Yellow = 75 and Green = 100).
I'd like to create an overall result for each column - sum the outputs (eg. 250), and divide by the number of rows (3).  This output i'll also conditionally format into a Red, Amber or Green result.

For an example of what each measure looks like, below is the first column.

TS_TSUtilisation_Score = 
IF(ISBLANK([InvoiceCount]),0,
IF([FMO_TSUtil_Measure]="N",25,
SWITCH(TRUE(),
[TS_TSUtilisation]="Y",100,
CALCULATE(COUNT(APAll[TS_TSUtilisation_InProgress]),APAll[TS_TSUtilisation_InProgress]="Yes")>0,75,
[TS_TSUtilisation]="N",50,0)))

[v-juanli-msft]

Hi @StidifordN 

You could sum measures with SUMX dax function.

https://docs.microsoft.com/en-us/dax/sumx-function-dax

If you have any problem to get correct result, please share some simple data.

Best Regards

Maggie

[amitchandak]

@StidifordN , In the Matrix conditional formatting you an option to show icon.

https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

there is also an option to show only icon