% based on 2 columns

[owenv]

I have a table of vehicles that have regular inspections. The same vehicle will appear in the table more than once. Sometimes that vehicle will pass an inspection and soemtimes it will fail. I need to calculate the percentage of inspections that result in a pass. It seems like this should be easy but the measure I'm using always returns 100% when I drag the vehicle ID in. The % is correct when I use a basic card that aggregates across the entire table.

The (rough) DAX I'm using at the moment:

VAR numberOfInspections = COUNTX('inspections', 'inspections'[_index])

RETURN CALCULATE(numberOfInspections, 'inspections'[pass] = TRUE()) / numberOfInspections

This works on a card that doesn't include vehicle names. But if I add a column chart with vehicle IDs, it displays 100% for each vehicle. What am I missing?

[ribisht17]

@owenv 

Hope this satisfies your requirement, if yes, kindly mark the answer as correct so that it can help others as well

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[ribisht17]

@owenv 

This should work >>>

Step 1

Total Vehicle = COUNTX(ALL(Vehicle), Vehicle[vehicle])

Step 2

Total Pass Vehicle = CALCULATE(count(Vehicle[Total Vehicle]),FILTER(all(Vehicle),Vehicle[pass]=true()))

Step3

Final % = [Total Pass Vehicle]/min(Vehicle[Total Vehicle])*100

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[ribisht17]

@owenv 

Please share your table then, hard to solve with this info

[owenv]

The below is an anonymised example. I'd expect to see 50% returned for each vehicle with these values.

vehicle	pass
vehicle 1	TRUE
vehicle 2	FALSE
vehicle 3	TRUE
vehicle 1	FALSE
vehicle 2	TRUE
vehicle 3	FALSE

[Ashish_Mathur · Accepted solution]

Hi,

Try these measures:

Row count = COUNTROWS(Data)

Pass count = CALCULATE([Row count],Data[pass]=TRUE())

Pass % = DIVIDE([Pass count],[Row count])

Hope this helps.

[owenv]

Many thanks 

[Ashish_Mathur]

You are welcome.

[ribisht17]

@owenv  , I hope that it helped, if yes, please mark the answer or let us know

Ritesh

[ribisht17]

@owenv 

Use ALL so that it can come out of the Row Context there .....

Use this DAX = VAR numberOfInspections = COUNTX(ALL('inspections'), 'inspections'[_index])

Regards,

Ritesh

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[owenv]

Thanks for the input. Unfortunately it hasn't solved the situation