Forum Discussion
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.
1 Reply
- v-janeyg-msft
Community Support
Hi, izhelezniakov
Only the test messageText table appears in your measure, and there is no syntax problem,so it’s hard to tell where your problem is, maybe you need to read this document first:How to Get Your Question Answered Quickly - Microsoft Power BI Community
If you add more useful information, please feel free to ask me.
Best Regards
Janey Guo