Forum Discussion
Total in Table Not showing
- 5 years ago
Read my article here. https://exceleratorbi.com.au/use-sum-vs-sumx/#totals
Assuming your columns process A and Process B are in the same table along with the data, try this
=SUMX(summarize(tableName,TableName[Process A],TableName[Process B]), CALCULATE(whatever you have already written in your measure goes here))
- 5 years ago
It's hard to say without seeing the model. I can now see there are at least 2 tables, maybe more. It's impossible to say without seeing the tables, relationships, which columns are in each table, and what the quality score measure is.
hi thanks for this! this looks promising as it started with summarizing. however, i got an error in loading this measure. Do you know what's off?
OH NO. i just had an extra ) but this works now! super thanks Matt!