Forum Discussion
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'...
# 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?
remove =1