Forum Discussion

RenateBK's avatar
RenateBK
Icon for Helper II rankHelper II
9 months ago
Solved

Cumulative Distinct Count per year, per category, query exceeds available resources issue

Hello,    I'm working with a data set where I need to calculate the cumulative distinctcount per category per year and I'm running into an issue of query time out/exceeding available resources.   ...
Need Help
  • amitchandak's avatar
    amitchandak
    9 months ago

    RenateBK , try like 

     

    AmountCases = CALCULATE(Countrows(Values(Table1[CaseID]) ))

     

    or

     

    AmountCases = CALCULATE(Countrows(Summmarize(filter(Table1, Table1[CaseID] <> Blank()), [CaseID])  ))

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
9 months ago

Hi,

Does this work any better?

=calculate(distinctcount('Table1'[CaseID]),datesytd(calendar[date],"31/12"))