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

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.

    • TomMartens's avatar
      TomMartens
      Super User
      9 years ago

      Glad we were able to help once again.

       

      Maybe you also consider to create another measure lilke this

      No of Cases = 
CALCULATE(
	DISTINCTCOUNT('Table1'[CaseID])
)

      Personally I find such a measure really beneficial in combination with columns like "latest status"

       

      Cheers