How do I sum a variable?

[jayjay0306]

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 measure.

In other words, I have the following setup(example):

and I need the following result (when I "collapse" the table):

I have tried to make the following measure:

No of customers, who are red = 
VAR Is_RED=NOT(ISBLANK(VALUES('table'[Is_RED])))
VAR RED_flag=IF(Is_RED,1,BLANK())
RETURN
RED_flag

Which flags the correct customers. But when I collapse the table, I get this:

How do I sum (or count) the customers on a aggregated lavel?

thanks.

Br,

JayJay0306

[jayjay0306]

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

[danextian · Accepted solution]

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] )