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?

[v-prasare]

May I ask if you have resolved this issue? If so, Can you please share the resolution steps here. This will be helpful for other community members who have similar problems to solve it faster.
If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

Hi @JDES2025,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[v-prasare]

Hi @JDES2025,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@Royel & @MasonMA ,Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support

[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 · Accepted solution]

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