DAX Help

[joshik]

Hi All,
I have a question regrading using Filters in DAX.
IPA = FILTER('Database','Database'[CT]= 60 && 'Database'[DD] = 1)
DAX comparison operations do not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
Can someone help me with it?
Thank you.

 

[Matt Allington]

Yes. One or both of your columns must be formatted as text. Either change the column to number or change your filter.
FILTER('Database','Database'[CT]= “60” && 'Database'[DD] = ”1”)

btw, your formula is not valid anyway as you can’t return a table in a measure or a column.

 

[joshik]

Yes. One or both of your columns must be formatted as text. Either change the column to number or change your filter.
FILTER('Database','Database'[CT]= “60” && 'Database'[DD] = ”1”)

btw, your formula is not valid anyway as you can’t return a table in a measure or a column.

Can you help me, how to use filters for two different column name?

 

[Matt Allington]

There is nothing wrong with the filter function. It is just that it can't be used on its own. You need something like this

CALCULATE([Total Sales],filter(Products,Products[Category]="Bikes" && Products[Color]="Red"))