Forum Discussion
yasbos
Resolver II
Resolver IISummarize table with column from a related table
Hi. I'm using sumarizecolumns in dax studio to summarize three columns from table t1 and a column from related table t2, where the relationship is t1 *----1 t2 (many to one where t2 is on the one ...
It turns out I did have a syntax error indeed where I had an extra "=" sign. The mystry is why did power bi not show a red triangle next to the measure name and didn't give me any indication that the measure had a syntax error until I used it in a visual.
yasbosResolver II
Resolver IIUPDATE: I used groupby. That remedied the above error. However, I needed to now sum up the above calculated column "Target", since this is really my ultimate goal from this measue, so I did a sumx on the Target field of the table output from groupby.I then got this error on the visula (although the measure didn't seemt ot have errors) : "The measure .... seems to be missing an argument to an arithmetic or to a semantic operator. Please review its expression"