Forum Discussion
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 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
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] )
2 Replies
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] )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
