How can I get the total from the excel, in power bi the total that is showing is from the formula N83:Q83 not the total from the after the formula.
Hi @Fraizerrrrr ,
For this you need to a SUMX formula should be similar to this:
WTD Actual Total = SUMX(VALUES(Table[Line Assignment]), [WTD Actual Output])Be aware that this is a new measure that will use the one you have currently so in term of the visualization you should use this one.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Fraizerrrrr ,
For this you need to a SUMX formula should be similar to this:
WTD Actual Total = SUMX(VALUES(Table[Line Assignment]), [WTD Actual Output])Be aware that this is a new measure that will use the one you have currently so in term of the visualization you should use this one.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Data Days 2026
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
