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

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi RenateBK,

I would also take a moment to thank Ashish_Mathur  , amitchandak  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi RenateBK,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.