dax count 0 and 1

[Anonymous]

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

[Nathaniel_C · Accepted 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]))

[Anonymous]

How can I group this by date, day of week

[Anonymous]

Thank You