Forum Discussion

cebd_31's avatar
cebd_31
Regular Visitor
5 years ago
Solved

Need Help With Yes/No Daily Chart

Hello,   New user here, can someone please assist me with below?   I have a chart I need to create that is based of a Yes/No Column, I used the following formula:   % Yes/No = DIVIDE(COUNT(Tab...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    cebd_31 , Try like

    % Yes/No = DIVIDE(COUNT(Table2[Yes/No]),CALCULATE(COUNT(Table2[Yes/No]),ALLexpect(Table2, Table2[day])))

amitchandak's avatar
amitchandak
Super User
5 years ago

cebd_31 , Try like

% Yes/No = DIVIDE(COUNT(Table2[Yes/No]),CALCULATE(COUNT(Table2[Yes/No]),ALLexpect(Table2, Table2[day])))

  • richbenmintz's avatar
    richbenmintz
    Resident Rockstar
    5 years ago

    Hi cebd_31 ,

     

    You could do it with a couple of measures as well

     

    Yes = divide(
calculate(countrows('table2'),'table2'[Yes/No] = "Yes"), calculate(countrows('table2'),  ALL ( Table2[Yes/No] ))

No= divide(
calculate(countrows('table2'),'table2'[Yes/No] = "No"), calculate(countrows('table2'),  ALL ( Table2[Yes/No] ))

     

     

  • cebd_31's avatar
    cebd_31
    Regular Visitor
    5 years ago

    You are awesome my man!!