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
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
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.
