Forum Discussion

jayjay0306's avatar
jayjay0306
Icon for Helper III rankHelper 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] )
danextian's avatar
danextian
Icon for Super User rankSuper User
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] )