Sum rows of multiple measures

[PabloGiraldo]

Hi,

I created multiple measures and need to sum specific ones multipied by 100 to get % Complete to Date for AW Field, AW Management, and B/C. Then put the sum into a card. 

I will then have to create another table with all measures shown below PLUS 4 other measures to get % Complete to Date Project As a Whole.

PBIX file below for reference.

https://walshgroup-my.sharepoint.com/:u:/p/pgiraldoclavijo/EeRZ1RnR54FHuGfnzEhNAfIBas_vf1tJLu8assqhe... 

[ryan_mayu · Accepted solution]

@PabloGiraldo 

you can try this

%Complete to Date = ([AW Field Measure]+[AW Management Measure]+[B/C Measure])*100

[v-jayw-msft · Accepted solution]

Hi @PabloGiraldo ,

If you just want to simply sum the vaules of measures you could you could directly use "+", like:

(measure1+measure2+measure3+...)*100

If I misunderstand your meaning, please show more details.

Best Regards,

Jay

[ryan_mayu · Accepted solution]

@PabloGiraldo 

you can try this

%Complete to Date = ([AW Field Measure]+[AW Management Measure]+[B/C Measure])*100

[amitchandak]

@PabloGiraldo , I create a measure

Measure = ([AW Field Measure]+ [AW Management Measure] + [Berkel Measure])*100

Added that to Table and gor value 4.15, not sure that is correct.