Count

[gauravnarchal]

Need help!!

I need  to create a measure to count total number of {True} users for each company. Can you please help?

[AntrikshSharma · Accepted solution]

@gauravnarchal  Use this:

=
CALCULATE (
    DISTINCTCOUNT ( Table[Name] ),
    Table[is_active] = TRUE ()
)

[negi007 · Accepted solution]

@gauravnarchal You can create below measure 

Total_True_USer = CALCULATE(DISTINCTCOUNT('Table'[Company_Name]),'Table'[is_active]=TRUE())

[AntrikshSharma · Accepted solution]

@gauravnarchal  Use this:

=
CALCULATE (
    DISTINCTCOUNT ( Table[Name] ),
    Table[is_active] = TRUE ()
)