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(Table2[Yes/No]),CALCULATE(COUNT(Table2[Yes/No]),ALL(Table2)))
 
And I am getting below Chart:

 

 

However, issue is that I need the percentage to be daily, not total from the entire information and I am unsure on how to accomplish this.

 

Thanks in advance.

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

5 Replies

  • 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.

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