Forum Discussion

izhelezniakov's avatar
izhelezniakov
New Member
5 years ago

CONTAINSSTRING filter in Calculate DAX function used on aggregated table causes unexpected error

Measure =
CALCULATE(
    SUM('test messageText'[counter]),
CONTAINSSTRING('test messageText'[modes], "email")
    )

 

I have a table messageText and it's aggregated analog messageText_agg. In "manage aggregations" menu for messageText_agg the group by fields are connected meessageText_agg.counter > SUM (messageText.counter), messageText_agg.modes > GROUP BY messageText.modes.

 

The calculation flows through aggregated table (stored in Import mode) if no filters used or if simple filters used (ex.: messateText.modes = "email"). When applying CONTAINSSTRING filter, the visual returns unexpected error.

 

The original table is connected via DQ to Azure Analysis Services. Same filter works fine if the aggregated table excluded from the model. The dimensional tables are in "Dual" storage mode.