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 

     

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.

     

    • TomMartens's avatar
      TomMartens
      Super User
      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 

       

      • cshashank's avatar
        cshashank
        Frequent Visitor
        9 years ago

        Thank you so much, 

         

        I took the hint from smoupre solution and create a measure like: 

         

        FAIL= CALCULATE(DISTINCTCOUNT(testcasetbl[TCtitle]),FILTER('SmokeCase',[Latest Status]="FAIL"))

         

        But your solution is definitely much simpler. Thanks a alot.