Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!!!
Solved! Go to 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))
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.
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
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)
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?
OH NO. i just had an extra ) but this works now! super thanks Matt!
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.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |