Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count of Previous Case Values

Hi Everyone,   i have a case table connected to Case Log via Case ID and a Account/Client table connected to case via Account ID.  case :  CASE ID     CASE NO    ACCOUNT ID    OTHER COLS ...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a measure.

    Measure = CALCULATE(COUNT('case log'[ID]),FILTER(ALL('case log'),'case log'[Case ID]=SELECTEDVALUE('case'[CASE NO])))

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Ahh yes, sorry for the confusion.
The [Case TABLE] has a (CreatedDate) Col. 
So i want to get the previous cases by an account i'll have to filter by date but will it give all the previous cases ? 

 

Regards,

Shubham

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure = CALCULATE(COUNT('case log'[ID]),FILTER(ALL('case log'),'case log'[Case ID]=SELECTEDVALUE('case'[CASE NO])))

 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.