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,

 

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.

      • 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