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

     

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