Forum Discussion
Dax Measure - Average including filter
Morning I've calulated an avg. value, now I need to create 3 more split by type, I need this to be displayed on one line chart. Can anyone help with the dax formular to add a filter on to th...
Thank you for your help - got this error when I tried
The following syntax error occurred during parsing: Invalid token, Line 2, Offset 50, 'On Street"))))))).
hi KayCon
Be careful about unclosing brakets and the DataSlayer's code shall work. Can you make a screenshot of the issue?
Or try a simplified code like this:
AvgType1 = CALCULATE([AvgValue], Details[Type] = "Type1")
AvgType2 = CALCULATE([AvgValue], Details[Type] = "Type2")
AvgType3 = CALCULATE([AvgValue], Details[Type] = "Type3")
p.s. please consider @someone, if you seek further suggestions.