Forum Discussion

cshashank's avatar
cshashank
Frequent Visitor
9 years ago
Solved

DAX Help: Extract value based on last execution

Hi,   I have a below scenario: Timestamp CaseID CaseTitle Status 8-16-2017 5:00 1 TestCase A Pass 8-16-2017 5:00 2 TestCase B Pass 8-16-2017 5:00 3 TestCase C Pass 8-16-...
Need Help
  • TomMartens's avatar
    TomMartens
    9 years ago

    Hey,

     

    maybe this would be a solution, I'm counting the caseid (distinct count) to get the numbers in this table

    I did not use a measure I just changed the Aggregate function in the visuals pane and renamed the column in the visual

     

    Maybe now I'm getting closer 

     

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

I created a calculated column using this DAX

Latest Status = 
var currentCaseID = 'Table1'[CaseID]
var maxTimeStamp = CALCULATE(
    MAX('Table1'[Timestamp])
    ,ALLEXCEPT('Table1',Table1[CaseID],Table1[CaseTitle])
)
return
LOOKUPVALUE(Table1[Status], 'Table1'[Timestamp], maxtimestamp, Table1[CaseID], currentCaseID)

 The values for this column will look like this

 

A possible visualization could be

 

 

Hope this helps somehow

 

 

  • cshashank's avatar
    cshashank
    Frequent Visitor
    9 years ago

    How can I achieve the desired result?

     

    Its still going to show me 2 pass 8 Fail

  • cshashank's avatar
    cshashank
    Frequent Visitor
    9 years ago

    How can I achieve the desired result?

     

    Its still going to show me 2 pass 8 Fail

    • TomMartens's avatar
      TomMartens
      Super User
      9 years ago

      Hey,

       

      can you please share which approach you are using and provide an image of your visualization.

       

      Cheers

      • cshashank's avatar
        cshashank
        Frequent Visitor
        9 years ago

        I used your approach only, and get the last status successfully,

         

         

        Now i need to show the Numbers, or passing percentage/pie chart, and that is causing a problem.