Forum Discussion

jeromeianmpbi's avatar
jeromeianmpbi
New Member
5 years ago
Solved

Total in Table Not showing

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]) ...
Need Help
Tutorial Requests
  • MattAllington's avatar
    MattAllington
    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))

     

     

  • MattAllington's avatar
    MattAllington
    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. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
jeromeianmpbi
New Member
5 years ago

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)