Forum Discussion

KevDavies's avatar
KevDavies
New Member
4 years ago
Solved

Measure Conundrum

Hi All,  New to BI and am struggling with the syntax for a measure.    Table = Investigations Field 1 = Locality Field 2 = Count of Investigations   The visual gives me a count of investigatio...
Need Help
  • misaki233's avatar
    misaki233
    4 years ago

    Hi KevDavies 

    Create a new measure like

    Measure = COUNT('Table'[Investigations])

    or 

    Measure = COUNTROWS('Table')

    The 'Table'  here refers to the table you use.

     

KevDavies's avatar
KevDavies
New Member
4 years ago

Hi misaki233 

Thanks fot eh suport, getting the information in the visual is not the problem, I need it in a measure so I can make other calculations based on the individual localities.

 

Regards

 

KD

misaki233's avatar
misaki233
Helper II
4 years ago

Hi KevDavies 

Create a new measure like

Measure = COUNT('Table'[Investigations])

or 

Measure = COUNTROWS('Table')

The 'Table'  here refers to the table you use.

 

  • KevDavies's avatar
    KevDavies
    New Member
    4 years ago

    misaki233 , Thank you so much, that worked.

     

    Appreciate the swift response

     

    KD