Forum Discussion

walkeras's avatar
walkeras
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Count the frequency of a boolean value

Hello everyone,   I have a database that stores the boolean values of a field that was collected. I am trying to count the frequency that the value appears i.e. the strucutre looks something like t...
Tutorial Requests
  • walkeras's avatar
    walkeras
    9 years ago

    Hey,

     

    Last night I had a brainwave and jumped out of bed and got it working using the following formula:

     

    TrueCount = COUNTAX(FILTER('Table',[Element_A]=TRUE()),TRUE())

     

    Thanks for the additional inputs as well, I will have a play with those other suggestions to see how else I might be able to solve the problem.

walkeras's avatar
walkeras
Icon for Advocate I rankAdvocate I
9 years ago

Hey,

 

Last night I had a brainwave and jumped out of bed and got it working using the following formula:

 

TrueCount = COUNTAX(FILTER('Table',[Element_A]=TRUE()),TRUE())

 

Thanks for the additional inputs as well, I will have a play with those other suggestions to see how else I might be able to solve the problem.

Bhavana_k's avatar
Bhavana_k
Icon for Helper I rankHelper I
7 years ago

Hi,

 

My scenario is something similar but I have many conditions. Like below
if category="Good" then count(Column)

else if category = "bad" then count(Column)

else if category ="neutral" then count(Column)

else

blank()

END

How do i do this?
I tried it with if and switch condition but its not working.
CheckCount =
IF([Category]="Danger",COUNT(Table1[Column1]),
IF([Category]="Bad",COUNT(Table1[Column1]),
IF([Category]="Good",COUNT(Table1[Column1]),
IF([Category]="Neutral",COUNT(Table1[Column1]),
IF([Category]="very Good",COUNT(Table1[Column1])
,BLANK())
) ) ) )

And this category is a measure which I have made. But now i just want a count of these categories so i can make some pie ot donought chart.

Thank you,
Bhavana