Forum Discussion
Solved
SUMX CALCULATION TOTAL
Hello, I'm New to Power BI, Can you please help me with SUMX formula to calculate total value of a colone mesure ? My data table in Excel is like Pic1, and the table in Powzer BI is like Pic2...
Hi Yunxijiang，
You could create the formulas like below.
Measure = SUMX('Table1',[GAP_1]) Measure 2 = SUMX('Table1',[GAP_2]) Measure 3 = SUMX('Table1','Table1'[GAP_3]) Measure 4 = [Measure]+[Measure 2]+[Measure 3]Here is the result output.
If you only need the measure 4, you also could modify the measure to Measure 5 = SUMX('Table1',[Measure])+SUMX('Table1',[Measure 2])+SUMX('Table1',[Measure 3])
Hope this can help you!
Best Regards,
Cherry
v-piga-msft
Resident Rockstar
Resident Rockstar