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. 

akyler's avatar
akyler
Regular Visitor
8 years ago

 In general, I think DISTINCTCOUNT causes performance issues.  COUNTROWS on a summarized table might actually provide much better performance.  Something like:

 

=COUNTROWS(
  SUMMARIZE(
    FILTER('raw data',
      [Country] = EARLIER([Country])
      &&[System] = EARLIER([System])
      &&[Access Risk ID] = EARLIER([Access Risk ID])
      &&[Composite/Business Role] = EARLIER([Composite/Business Role]))
   ,[User ID]))