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_History__c"]}[Data]

 

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

What am I doing wrong?

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

     

5 Replies

  • MasonMA's avatar
    MasonMA
    Super User
    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] )
)

     

  • Royel's avatar
    Royel
    Super User
    11 months ago

    Hi Anonymous 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 

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

    Hi Anonymous,

    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

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

    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'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.