Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I want to ask how the expression below
If I have a table
100
0
0
100
100
100
N / A
The calculation is:
1 Count 100 how many (A)
2 Count 0 how many (B)
X = A / (A + B)
The above example is: X = 4/6 X = 0.667
Thank you
Anto
Solved! Go to Solution.
Hi @Anonymous ,
Use DIVIDE so you do not get an error if happen to divide by zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100) Count zero = CALCULATE(COUNT('Table'[Column1]),'Table'[Column1]=0) Percentage of Count = DIVIDE([Count 2],([Count 2]+[Count zero]))
Proud to be a Super User!
Hi @Anonymous ,
Use DIVIDE so you do not get an error if happen to divide by zero.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Count 2 = Calculate (COUNT('Table'[Column1]),'Table'[Column1]=100) Count zero = CALCULATE(COUNT('Table'[Column1]),'Table'[Column1]=0) Percentage of Count = DIVIDE([Count 2],([Count 2]+[Count zero]))
Proud to be a Super User!
How can I group this by date, day of week
Thank You
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
22 | |
17 | |
11 | |
11 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |