March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
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.
Solved! Go to Solution.
@cebd_31 , Try like
% Yes/No = DIVIDE(COUNT(Table2[Yes/No]),CALCULATE(COUNT(Table2[Yes/No]),ALLexpect(Table2, Table2[day])))
@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] ))
Proud to be a 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
That should work.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
90 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |