Forum Discussion

muhssamy's avatar
muhssamy
Resolver I
1 year ago
Solved

Trace Event Aggregate Table Rewrite Info

Dears

i am seeking help in this trace message that i am not able to troubleshoot 

 

Matching aggregations is limited due to capabilities of one or more datasources:
{
"restrictedDatasources": [
{
"name": "<ccon>Import</ccon>",
"reason": "multiple aggregations not supported by Import when distinct count is present"
}
]
}

this issue happens when i am calling Basket Size Measure which is defined as the following

 

 

DEFINE
    MEASURE 'Measures Table'[$ Basket Size] =
        DIVIDE (
            [$ Revenue],
            [# Transactions],
            0
        )
    MEASURE 'Measures Table'[$ Revenue] =
        SUM ( Sales[TRANS_VALUE] )
    MEASURE 'Measures Table'[# Transactions] =
        DISTINCTCOUNT ( Sales[Invoice Line ID] ) 

EVALUATE
SUMMARIZECOLUMNS (
    "BS", IGNORE ( [$ Basket Size] )
)

 

 

 

BUT

when i run the following code

 

 

EVALUATE
SUMMARIZECOLUMNS(
    Stores[Country Global],
    KEEPFILTERS( TREATAS( {2024}, 'Date'[Year] )),
    "$ Basket Size", [$ Basket Size]
)
ORDER BY 
    Stores[Country Global] ASC

 

 

 

it hits the aggregates 

first i receive in Aggregate Table Rewrite Info Even:- 

Disabling table literal remoting due to possibility of matching to an Import aggregation table

then in Aggregate Table Rewrite Query Event i receive matchFound