Forum Discussion

Corleen's avatar
Corleen
Regular Visitor
9 years ago

Count a Measure or Countif

Good day   Please assist   I've created a measure to count how many times a person id comes forth in the data.   # times = CALCULATE(COUNT('TransactionDetails'[SYSTEM_NUM]),'TransactionDetails'...
Need Help
Corleen's avatar
Corleen
Regular Visitor
9 years ago

Phil_Seamark

 

Thank you for your reply.

But it is a measure not a calculated column 

 

For eg.

 

Trans Once = count([# times] = 1) I want the answer for this, how to do this?

Trans Twice = count([# times] = 2) ect.

where 

[# times] = CALCULATE(COUNT('TransDetail'[SYSTEM_NUM]),'TransDetail'[EARN_DEDUCT_IND]=1)  (this is a measure)

 

Thanks

Amratya's avatar
Amratya
Advocate I
9 years ago

Can you try the same formula for the measure and check what it results?

  • Corleen's avatar
    Corleen
    Regular Visitor
    9 years ago

    # times =

    CALCULATE(

                       COUNTROWS('TransDetail'),

                                              ALLEXCEPT('TransDetail',

                                                                                     'TransDetail'[SYSTEM_NUM],

                                                                                       'TransDetail'[EARN_DEDUCT_IND]=1) 'the underline part gives an error'

    )t

     

    ! A single value for column EARN_DEDUCT_IND  in TransDetail cannot be determined. THis can happen when a measure formula to a column that contains many values without specifying an aggregation such as min, max, count or sum to get to a single result.

     

    Is this what you meant? 

    • Amratya's avatar
      Amratya
      Advocate I
      9 years ago

      remove =1

      • Corleen's avatar
        Corleen
        Regular Visitor
        9 years ago

        I have removed the 1 and it gives me a result.

        But not the result what I want.

         

        Would please explain the Measure to me

         

        Thank you

    • v-caliao-msft's avatar
      v-caliao-msft
      Microsoft Employee
      9 years ago

      Corleen,

       

      Please try the DAX below.
      # times =
      CALCULATE(
                          COUNTROWS('TransDetail'),
                          FILTER(ALLEXCEPT('TransDetail',                                                                                        
                                                        'TransDetail'[SYSTEM_NUM]), 

                                     'TransDetail'[EARN_DEDUCT_IND]=1)
                          )

       

      Regards,

      Charlie Liao

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I am facing the same issue with getting count of measure output. Can you please help in providing the specific solution!

         

        Thanks