Forum Discussion
Aggregate calculated measure in table
Hi all,
I need help creating a calculated measure in a table similar to what a tuple would do back in the days of SSAS.
I have a table (see below) at the "order level" but would like to count the number of orders within a payment.
Help is much appreciated
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
2 Replies
SteveHaileySolution Specialist
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
ResultThanks. That worked once I put it in the right table.
Much appreciated!
