Forum Discussion

jayjay0306's avatar
jayjay0306
Helper III
2 years ago
Solved

How do I sum a variable?

Hi folks,   I hope you can help me here: I have a power BI report, where I need to calculate the share of customers, who are "RED" compared to total number of customers, and it needs to be a measu...
Tips and Tricks
  • danextian's avatar
    danextian
    2 years ago

    Hi jayjay0306 

    Try this

    =
SUMX ( VALUES ( 'table'[Customer] ), [No of customers, who are red measure] )

     

    That aside, I'm wondering why not use a simpler measure that counts the non-blank rows in Is_RED column

    = COUNTA( 'table'[Is_RED] )
jayjay0306's avatar
jayjay0306
Helper III
2 years ago

Thanks Danextian, your first solution works excellent. I forgot to tell, that the 'table'[is_red] is an expression I have made and not a table column. Hence, I can't us COUNTA(). But thanks anyway 🙂

br,

Jayjay0306