topic Re: HOW TO FILTER A COLUMN HAVING REFERENCE ANOTHER COLUMN WITH DIRECTQUERY in DAX Commands and Tips

HOW TO FILTER A COLUMN HAVING REFERENCE ANOTHER COLUMN WITH DIRECTQUERY

Daniels2204 — Tue, 25 Aug 2020 16:39:16 GMT

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 — Tue, 25 Aug 2020 15:11:30 GMT

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

Daniels2204 — Tue, 25 Aug 2020 16:38:35 GMT

This is my problem, pleaese your help.

camargos88 — Tue, 25 Aug 2020 18:50:03 GMT

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.