Forum Discussion
Aggregate calculated measure in table
I think you're asking for a calculated column, rather than a measure. If so, I would add a new calculated column that looks like the following:
Orders/Payment Count =
VAR PaymentReferenceOfCurrentRow = ( 'Table'[Payment Reference] )
VAR Result =
COUNTROWS (
FILTER ( Table, Table[Payment Reference] = PaymentReferenceOfCurrentRow )
)
RETURN
Result
Solution SpecialistI think you're asking for a calculated column, rather than a measure. If so, I would add a new calculated column that looks like the following:
Orders/Payment Count =
VAR PaymentReferenceOfCurrentRow = ( 'Table'[Payment Reference] )
VAR Result =
COUNTROWS (
FILTER ( Table, Table[Payment Reference] = PaymentReferenceOfCurrentRow )
)
RETURN
Result
Thanks. That worked once I put it in the right table.
Much appreciated!
