Forum Discussion
Total in Table Not showing
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))
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.
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))
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?
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.
OH NO. i just had an extra ) but this works now! super thanks Matt!