Aggregate calculated measure in table

[Finexio]

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

[SteveHailey · Accepted solution]

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

[Finexio]

Thanks.  That worked once I put it in the right table.  

Much appreciated!