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

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

Reply
Anonymous
Not applicable

dax count 0 and 1

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

1 ACCEPTED SOLUTION
Nathaniel_C
Community Champion
Community Champion

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

Count zero.PNG





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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Nathaniel_C
Community Champion
Community Champion

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

Count zero.PNG





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

Proud to be a Super User!




Anonymous
Not applicable

How can I group this by date, day of week

Anonymous
Not applicable

Thank You 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.