Total in Table Not showing

[jeromeianmpbi]

Hello all,

I need your help. I was trying to do a weighted score (Weighted Quality) for all of my scores so I made a new measure: Weighted Quality = [Quality Score] * MIN('Weighting'[Weighting]) and it worked. But unfortunately, the TOTALS at the bottom doesn't show the sum.

I tried replacing the MIN fx with SUM, but it didn't give me the correct weighted quality. I tried to convert the measure into a column to apply the SUM fxn, but it didn't work, either. 😕

Does anyone know how can I make another measure/column that shows the SUM of all values in the Weighted Quality measure? I can just hide the total in this table, but I need the sum value for another part of my dashboard.

Super thanks!!!

[MattAllington · Accepted solution]

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))

[Anonymous]

Hello @jeromeianmpbi ,

Does the Quality Score and Weighting column are the Actual columns of the table? or this are also the calculated filed/measures. 

As I can see the total of Quality Score 99.55% which doesn't seem the total

[jeromeianmpbi]

Hi.

Quality Score is a calculated measure (not a column) in the same table. it is then multiplied into weighting found in another table. The logic is that for every Process A has it's own weight (example Core =0.2, BP= 0.1)

[MattAllington · Accepted solution]

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))

[jeromeianmpbi]

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?

wq = SUMX(summarize(Main,Main[Process A], Main[Process B],

CALCULATE ([Quality Score]* MIN('Weighting'[Weighting]))))

[jeromeianmpbi]

OH NO. i just had an extra ) but this works now! super thanks Matt!

[MattAllington · Accepted solution]

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.