Hi, try with this:
CountYes = CALCULATE(COUNTA(Table1[A]),FILTER(Table1,Table1[B]="yes"))
%Yes of Total = DIVIDE([CountYes],CALCULATE(COUNTA(Table1[A]),ALLSELECTED(Table1)))
Lima - Peru
Proud to be a Datanaut!
View solution in original post
Thanks @atif-hafeez , appreciate.
@Vvelarde this did the trick also. cheers.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!