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