Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 months ago
Solved

DAX SUMMARIZE Function Table Name Error

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_Histor...
Need Help
  • MasonMA's avatar
    MasonMA
    11 months ago

     

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

     

v-prasare's avatar
v-prasare
Community Support
10 months ago

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.