Count a specific result from 2 columns

[pacifuentes]

Hi, Im new in this

I have an excel in this way:

ID	Test1	Test2
123	Positive
456	Negative
789		Negative
147	Positive
258	Positive
369	Negative
987		Positive
654		Positive

And I want to use a #KPI graphic with the results of only the sum of positive of both columns (test1 and test2)

Example result: 5 positive

In the Edit expression im using this expression and of course only count 1 column but I need both columns

Edit expression

Any idea how to resolve this?

Thanks

[kaushiknsolanki]

Hi,

You can try this.

Count({<Test1 = {"Positive"}>+<Test2 = {"Positive"}>}ID)

[pacifuentes · Accepted solution]

Thank you, it worked

[kaushiknsolanki · Accepted solution]

Please like and mark the post as the correct answer.