HOW TO FILTER A COLUMN HAVING REFERENCE ANOTHER COLUMN WITH DIRECTQUERY

[Daniels2204]

Hi, Guys

Today I´ve problem when filter the column (TL_QUANTID), I only need their values ​​when column (R_E_C_D_E__L) is at =0.

It generates an error related to columns, it has not been possible to relate them, keep in mind that I am working in Directquery mode.

In the dates only need the values in blue, but is not possible.

[amitchandak]

@Daniels2204 , what are trying to create where it is giving error. simple if should work as column in direct query

[Daniels2204]

Hi, @amitchandak 

This is my problem, pleaese your help.

[camargos88]

Hi @Daniels2204 ,

Can't you filter you query using R_E_C_D_E__L = 0 ?

Also, your code refers to FILTER function, it returns a filtered table, you have to return a scalar value in order to get it working.

In this example, you can create something like, for calculated tables:

Filter = IF(TABLE[R_E_C_D_E__L] = 0, 1, 0) 

And this for measures:

Filter = IF(SELECTEDVALUE(R_E_C_D_E__L) = 0, 1, 0)

and filter the results.

I wouldn't bring the rows to the model in your case, filtering directly on your Query.

You can filter it using Power Query using Query Folding, if you have a compatible data source with it.

https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding