Forum Discussion

jatneerjat's avatar
jatneerjat
Helper V
7 years ago

How to optimize below DAX

Hi TomMartens Ashish_Mathur Zubair_Muhammad  Greg_Deckler   How can i optimize below DAX as it currently affect the perfomance and the 'card with states' visual takes time to load.   AvgVal:= IF(...
Need Help
jatneerjat's avatar
jatneerjat
Helper V
7 years ago

Hi Greg_Deckler

 

Let me keep it more simple.I just want to optimize below statement,is it possible or it is already in a optimized way?

What is KEEPFILTERS and VALUES achieving here?

I just somehow want to replace AVERAGEX() with some other function.

 

AvgColumn1:= AVERAGEX(
KEEPFILTERS(VALUES('viewUser1'[UId])),
CALCULATE(DISTINCTCOUNT('viewUser1'[ApplicationId]))

Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

No, it doesn't look optimized at all quite frankly, but I can't determine if there is a better way of doing it without running some tests on some sample data. So, either provide that or I can't really help you.

  • jatneerjat's avatar
    jatneerjat
    Helper V
    7 years ago

    Hi Greg_Deckler

     

    The Userid and appid both are nvarchar and having 32 digit unique identifier.this table have total 20 columns and millions of records.

    In this table i have 6 ID  columns which are having type integer,2 date columns and 7 string columns.

     

    Thanks