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])))

AlB's avatar
AlB
Community Champion
5 years ago

Hi cebd_31 

Try

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

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

That should work.