Forum Discussion

jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
7 years ago

Dax filter() performance

Hi, Greg_Deckler Anonymous Stachu Could i replace below FILTER() function with some other function to improve performance     CALCULATE(DISTINCTCOUNT(vwFact[AppId]) ,FILTER(vwFact,vwFact[Area]=...
Need Help
jatneerjat's avatar
jatneerjat
Icon for Helper V rankHelper V
7 years ago

Hi v-jiascu-msft

 

I was not able to attach excel here in forum so adding the image for sample data.

this is for the first dax query.

 

 

Thanks

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi jatneerjat,

 

It seems the UIDs are unique. So the average could always be 1. What's the expected result of Query 1?

 

 

Best Regards,
Dale