Forum Discussion
Measure is not working in Direct Query mode
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 Dir...
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.