How do I add a specific value in a column with multiple values

[Marcegon]

Hello community! I am trying to add/count only the number "1" in a column with multiple values (see example below).
I tried to filter by "1" since I only want to show the volume by Planner in a visual, but I got an error.

What is the best way to obtain this?  Any help?

Planner	Attribute	Value
Mary	Attendees	1
Carmen	Vendor	Date
Ashley	Vendor	1
Bianca	Attendees	1480
Adam	Location	Christina
Carlos	Location	1

[Ashish_Mathur · Accepted solution]

Hi,

Ths measure will return 3 as the answer

Measure = calculate(countrows(Data),Data[Value]="1")

Hope this helps.

[Sahir_Maharaj]

Hello @Marcegon,

Since your Value column contains non-numeric values, you might need to create a calculated column first to convert non-numeric values, and then create a measure to count the 1s.

Value Numeric = IF(ISNUMBER('TableName'[Value]), 'TableName'[Value], BLANK())​

Should you require any further assistance, please do not hesitate to reach out to me.

[Marcegon]

Thank you!  For this particular case I ended up "converting the column to number, then replacing errors with "0", then filter by "1".