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.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!