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

# 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? 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hello,

     

    I am facing the same problem with getting count of measure. Can you please provide a relevent solution.

     

    Thanks,

    rax