Forum Discussion

Post Prodigy

6 years ago

Solved

Count

Need help!!

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

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

negi007
6 years ago
gauravnarchal You can create below measure
Total_True_USer = CALCULATE(DISTINCTCOUNT('Table'[Company_Name]),'Table'[is_active]=TRUE())

AntrikshSharma
Community Champion
6 years ago
gauravnarchal Use this:

= CALCULATE ( DISTINCTCOUNT ( Table[Name] ), Table[is_active] = TRUE () )
negi007
Community Champion
6 years ago
gauravnarchal You can create below measure
Total_True_USer = CALCULATE(DISTINCTCOUNT('Table'[Company_Name]),'Table'[is_active]=TRUE())