SUMIFS error in dax and creating a percentage column

[dax_questions13]

I am trying to create a sumifs funtion in DAX, here is what I have so far

SUMIF = CALCULATE(SUM('Table1'[Count]),FILTER('Table1','Table1'[Key] && 'Table1'[Values] <> ""))

When I input this I get an error message that says that "DAX comparison operations do not support comparing values of type integer with values of type Text. Consider using the VALUE or FORMAT function to covert one of the values." How can I fix this? 

Based on the error message I think the problem is that the [Key] column is in text format and [Values] column is in integer format and FILTER can't compare the 2. Not sure how I can fix this. I am very new to power BI, just learning. Thx for helping.

[davehus · Accepted solution]

Hi @dax_questions13 ,

You need to declare the requirement of the first filter in your context as highligted below. Also I recommend that you use <>BLANK() as opposed to <>"" or you could use NOT ISBLANK(ColumnName)

SUMIF = CALCULATE(SUM('Table1'[Count]),FILTER('Table1','Table1'[Key] && 'Table1'[Values] <> ""))

Hope this helps

Did I help you today? Please accept my solution and hit the Kudos button.

[dax_questions13]

That was helpful. <> Blank () did the trick. Thank you.