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
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