Forum Discussion
muhssamy
1 year agoResolver I
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
i found this video and it descipe the same issue and solution
Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI??? (youtube.com)
1 Reply
- muhssamyResolver I
i found this video and it descipe the same issue and solution
Why isn't my Agg hitting when using DISTINCTCOUNT in Power BI??? (youtube.com)