Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 i...
count 0 and 1
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Thank You