Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cebd_31
Regular Visitor

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:

 

Chart Example.png

 

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.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@cebd_31 , Try like

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

View solution in original post

5 REPLIES 5
amitchandak
Super User
Super User

@cebd_31 , Try like

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

You are awesome my man!!

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

 

 



I hope this helps,
Richard

Did I answer your question? Mark my post as a solution! Kudos Appreciated!

Proud to be a Super User!


AlB
Super User
Super User

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 

SU18_powerbi_badge

 

Anonymous
Not applicable

That should work.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors