topic Measure is not working in Direct Query mode in DAX Commands and Tips

Measure is not working in Direct Query mode

izineela — Thu, 20 Jul 2023 08:23:04 GMT

Hello everyone,

I am attempting to switch one table in my Power BI report from Import mode to DirectQuery mode.

The below measure code works correctly in Import mode but returns blank values in DirectQuery mode. Interestingly, when I manually input the property_id I use for filtering instead of using a variable, it works fine:

Here are the two tables I am using

And here is the DAX code

I have verified that the property_id is returning the expected IDs.

Any assistance you can provide on this matter would be highly appreciated.

Thank you.

Re: Measure is not working in Direct Query mode

v-jianboli-msft — Mon, 24 Jul 2023 03:03:11 GMT

Hi izineela ,

This issue may caused by the function FIRSTNONBLANK.

This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

You may need to modify your dax and use somthing else to replace it.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Measure is not working in Direct Query mode

izineela — Mon, 24 Jul 2023 13:51:08 GMT

Hello v-jianboli-msft, I attempted to use MAX instead, but the same error persists. Interestingly, when I output property_id, it appears to be populated correctly.