Forum Discussion

Fraizerrrrr's avatar
Fraizerrrrr
Frequent Visitor
2 years ago
Solved

Undefined

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.  
Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    2 years ago

    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.

MFelix's avatar
MFelix
Super User
2 years ago

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.