Measures working/showing correct with direct query

[Anonymous]

Hi, 

I have a datamodell with import and direct query tables. I have tried to make som simple measures but some works some does not.

example =blank works, but <>blank does not work. When I switch the direct query table into import then the measures work just fine and show the correct results. What are the limitation with measures and direct query??? 

No DirectQuery options are available.

[v-deddai1-msft]

Hi @Anonymous ,

What's your formula?I tested that <>blank() worked in dq mode? Please also refer to  https://docs.microsoft.com/en-us/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=asallproducts-allversions

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

Best Regards,

Dedmon Dai

[Anonymous]

Hi,

This is the measure that does not work properly:
calculate(distinctcount(table1[employeer_no],table1[employee_name]<>blank(),table1[active]=1)

This one works:
calculate(distinctcount(table1[employeer_no],table1[employee_name]=blank(),table1[active]=1)

[v-deddai1-msft]

Hi @Anonymous ,

Would you please try to use the following measure:

measure = CALCULATE(DISTINCT(table1[employeer_no]),FILTER(ALL(table1),table1[employeer_name]<>blank()&&table1[active] = 1))

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

Best Regards,

Dedmon Dai

[Pragati11]

Hi @Anonymous ,

There are certain limitations on using measures with Direct Query connection in Power BI:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

Most of the DAX functions are supported in direct query mode except few like Timeintelligence functions, etc.

Thanks,

Pragati