How to Calculate the expression with text and number format filters?

[Isiluzun]

Hello All,

I had a trouble with below measure.

Tons 2017 for A= calculate(SUM('Data dump'[Tons]), 'Data dump'[Year]=2017, 'Data dump'[Company]=A )

Year filter 2017 is in the number format while the company filter is in text format. I read that it is not possible to have mathematical calculation with a text filter so tried some other formulas to reach the desired measure but couldnt succeed. Any suggestions?

Many thanks in advance!

[Stachu · Accepted solution]

the error only shows up if you want to apply text filter to numeric column or the reverse
assuming 'Data dump'[Year] is numeric and 'Data Dump'[Company is text this should work:

Tons 2017 for A= CALCULATE(SUM('Data dump'[Tons]), 'Data dump'[Year]=2017, 'Data dump'[Company]="A" )

if 'Data dump'[Year] is also text then this should work

Tons 2017 for A= CALCULATE(SUM('Data dump'[Tons]), 'Data dump'[Year]="2017", 'Data dump'[Company]="A" )

[Isiluzun]

Thank you very much, it works now!