Forum Discussion

gauravnarchal's avatar
gauravnarchal
Icon for Post Prodigy rankPost 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?    
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    gauravnarchal  Use this:

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

     

  • negi007's avatar
    negi007
    6 years ago

    gauravnarchal You can create below measure 

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

     

     

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

gauravnarchal  Use this:

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