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

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