Forum Discussion
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
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.
NathanielCount 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]))
3 Replies
- Nathaniel_C
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.
NathanielCount 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]))