Calculate filter not working (Using DirectQuery for Power BI datasets and AAS (preview)

[RH-BIP]

Hi all,

This simple measure does not work anymore. Switched from import to DQ  (Using DirectQuery for Power BI datasets and AAS (preview)

Is this expected behavior? https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s... Maybe it is a limitation?

Measure 1 is correct, but Measure 2 should be way less. But it does not filter correctly, it is like the filter from TableCustomers is not filtering the SalesTable throughout TableDebtors. Hope somebody can help!

[v-easonf-msft]

Hi, @RH-BIP 

Have you checked the cross filter direction between tables?

Best Regards,
Community Support Team _ Eason

[RH-BIP]

Yes, look at the attached image. It is setup as 1 to many (single direction)

[v-easonf-msft]

Hi, @RH-BIP 

Could you please tell me whether your problem has been solved?

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @RH-BIP 

If your data is filtered like the following screenshot, you can use the field in 'TableCustomers' to filter the data in
'Sales table' but you cannot use the field in 'Sales table' to filter the data in 'TableCustomers'.

Maybe you need  change the filter direction between tables to bidirectional (both).

Best Regards,
Community Support Team _ Eason

[RH-BIP · Accepted solution]

Hi @v-easonf-msft 

Yes, I fixed the problem! I cannot change the direction in the datamodel to both because of other relations. But I fixed the problem with the dax function Crossfilter in the measure. I still do not understand fully why the filtering in a mixed storage mode behaves different from import..I hope I can find a good explanation somewhere. Any tips?