Forum Discussion

aviritia's avatar
aviritia
Frequent Visitor
8 years ago
Solved

Slow calculations with DISTINCTCOUNT

Hello Guys!   I have a list of users with all their accesses and I wanted to see how many users I have for the same country, same system, same risk ID and same business role. To achieve that I used...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    aviritia,

    This article gives a perfect explaination on why removing FILTER will speed up your DAX. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I ran into the similar issue while doing it in calculated column. Can you post the formula that you modified to make it work.

 

Appreciate any help!