Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create IF measure summing one column based on another column

I need a measure that states:   If this Table1[company ID] = “1055”, then Do this calculation:   Calculate(     SUM(Table1[count]) * 0.50,Table1[PrdType] = "Unit Production")   Else do this c...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    I appreciate your work on this.  This seems to be the same as what I had done yesterday.  The measure seems to be working without errors; however, I do not get any results.  I think I will break the measure apart to understand what part is breaking for my larger tables.  I appreciate the assistance.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I appreciate your work on this.  This seems to be the same as what I had done yesterday.  The measure seems to be working without errors; however, I do not get any results.  I think I will break the measure apart to understand what part is breaking for my larger tables.  I appreciate the assistance.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I have a followup issue.  The measure now works on the specific row; however, the sum of the column is still the total, it does not consider the measure calculation.  How can I get the sum to match the numbers in the column?