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

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