cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: DAX Help: Extract value based on last execution

Please forgive my slow thinking, but I have no idea what is do mean by grouping, please provide a visual like so

Value of latest Execution 2.png

And also provide input what approach of the suggestions you are using

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
cshashank Frequent Visitor
Frequent Visitor

Re: DAX Help: Extract value based on last execution

I just wanted to show Pass/Fail in Pie Chart rather than column chart.

Super User
Super User

Re: DAX Help: Extract value based on last execution

Hey,

 

maybe this would be a solution, I'm counting the caseid (distinct count) to get the numbers in this table

Value of latest Execution 3.png

I did not use a measure I just changed the Aggregate function in the visuals pane and renamed the column in the visual

Value of latest Execution 4.png

 

Maybe now I'm getting closer 

 

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
cshashank Frequent Visitor
Frequent Visitor

Re: DAX Help: Extract value based on last execution

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.

Super User
Super User

Re: DAX Help: Extract value based on last execution

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

Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 44 members 1,143 guests
Please welcome our newest community members: