DAX SUMMARIZE Function Table Name Error

[JDES2025]

I am trying to write a SUMMARIZE function, I know I need to have the table name next,

Which I know is “Booking_History__c” from the Transform data pane...

= Source{[Name="Booking_History__c"]}[Data]

But when I type in the table name, I keep getting the same error,

What am I doing wrong?

[Royel]

Hi @JDES2025 visual calculation dose not allow summarize() you need to create a table or measure. If table format works you can try the proposed solution from @MasonMA or if you like to do it using measure try this 

Summarized_Measure = 
SUMX(
    SUMMARIZE(
        'Booking_History__c',
        'Booking_History__c'[BookingID],
        'Booking_History__c'[CustomerID]
    ),
    SUM ( 'Booking_History__c'[SalesAmount] )
)

You can learn more about summarize() function in here 

Thanks 

[MasonMA]

Hi,

In a visual calculation, you don’t directly reference model tables the same way you do in a standard DAX expression.

That’s why when type SUMMARIZE() you get the table name error.

If you want to use SUMMARIZE, please create a calculated table or measure in the model, not in a visual calculation.

For example: 

NewTable =
SUMMARIZE (
    'Booking_History__c',
    'Booking_History__c'[BookingID],
    'Booking_History__c'[CustomerID],
    "Total Sales", SUM ( 'Booking_History__c'[SalesAmount] )
)