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

Hi , yes sure
[Account Table] --one to many -- [Case Table]
[Case Table] -- one to many -- [Case Log Table]
A case is logged by an account into [Case Table] and the multiple entries are made about that Case in [Case Log] Table.


I want to get is the Lastest case registered by an Account and the second last case registered by them.

Regards,

Shubham

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I have a measure which gives me the no. of times the case came back to the department.

So eventually i want to
Calculate([measure], latest case) --- i.e comeback count for lastest case w.r.t account name &
Calculate([measure], second last case)-- for same account.

Hope it's clear. Appreciate any help.

thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous , 

    What is the lateset case? How to get it? By End time or start time?  In your sample, the lateset case is ASGHVJ?  If it is, does the measure result is 3?   The below? 

    asvdsahvhsg677 ASGHVJ        
    sahgxsakjaw223 ASGHVJ        
    sdcsavbhsa677 ASGHVJ

     

    I would like you to give me a table that outputs what you want and explains the calculation method in words. Sorry to trouble you.

     

    How to Get Your Question Answered Quickly 

     

    Please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    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.