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

Hello,

 

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

 

Thanks,

rax