So the summarize function dont seem to work as expected, see below. The error does not make sense, since the expression is merely a sum(table[tonnes column) and I just saw someone in a youtube video using it the exact same way?
The SUMMARIZE command will create a new table. It really seems you're trying to use it in a measure, which will not work. So, first make sure you are at the "Data view" when you use it (not on the report view). I'd also make sure that your columns/fields, such as "Tonnes & Carats" are properly reference, usually in the "Table[Field]" format.
Now, I have created a relationship between those two tables using "Account" column and created a Cust Grp column in TBL using Related(CUST[Grp]). I want build a customer count based on grouping.
Counts were fine when there were no filters applied but when I apply a filter on TBL tables Sale amount in CUST table is not filtering(I selected filtering as Both direction). As a result, counts in the group are not being calculated properly.
For example, if I filter country in TBL to the "USA" the premium in the CUST table is not changing.