Forum Discussion

Datatouille's avatar
Datatouille
Solution Sage
9 years ago

DAX Measure Performance and Many-To-Many

Hello everyone,   I am currently preparing a webinar on 'Many to Many in DAX' for the 2nd French edition of the 24 Hours Of PASS: 24 webinars of one hour each dedicated to Microsoft technologies ar...
Need Help
MattAllington's avatar
MattAllington
Community Champion
9 years ago

1.  Are you clearing the cache for the second run?  I would expect this to be a cache benefit on 2+.  If you are clearing the cache, then I have no idea 

2. You cannot rely on time accuracy below a few hundred milliseconds.  This is taught by Marco in Optimising DAX

3.  I wonder if the cache clearing is working - I dont know. 

4. Dont know

5. I ma not aware of the problem. 

  • Datatouille's avatar
    Datatouille
    Solution Sage
    9 years ago

    Hi MattAllington

     

    Thanks for your reply.

    Yes I am clearing the cache !

     

    Enable CrossFilter in DirectQuery is no longer a preview feature but I still do not understand why I need to tick it to make Row-Level Security and Many-To-Many work even when I am not in DirectQuery mode.