Forum Discussion
Solved
% based on 2 columns
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 t...
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.
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
Thanks for the input. Unfortunately it hasn't solved the situation