I have a below scenario:
One set of cases executed twice daily. I need to show the count of Pass/Fail based on the last execution.
How can I achieve this?
Currently i group them via date, it shows me 4 pass and 6 fail,.
The desired output should be 1 Pass/ 4 Fail
Go to Solution.
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
How about some measures like this:
Pass = CALCULATE(COUNTA('Cases'[Status]),FILTER('Cases','Cases'[Timestamp]=MAX('Cases'[Timestamp])),FILTER('Cases',[Status]="Pass") )Fail = CALCULATE(COUNTA('Cases'[Status]),FILTER('Cases','Cases'[Timestamp]=MAX('Cases'[Timestamp])),FILTER('Cases',[Status]="Fail") )
Proud to be a Datanaut!
This should be giving you the desired results since your date col also got time. If not, may be put the time of execution in a seperate col and then group the data based upon date and later by time .
you could also do this @cshashank
create the max date
(its a measure)
lastdate = max(Table1[Timestamp])
and then create another measure
Measure 2 = CALCULATE(COUNTROWS('Table1'), FILTER('Table1', Table1[Timestamp] = max(Table1[Timestamp])))
place them both on a visual
I created a calculated column using this DAX
Latest Status =
var currentCaseID = 'Table1'[CaseID]
var maxTimeStamp = CALCULATE(
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
How can I achieve the desired result?
Its still going to show me 2 pass 8 Fail
can you please share which approach you are using and provide an image of your visualization.
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.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.