Forum Discussion
Create IF measure summing one column based on another column
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.
company ID PrdType Count dateend
1055 Unit Production 16438 12/31/2021
1055 Unit Production 18540 11/30/2021
1055 Unit Production 18516 10/31/2021
1343 Unit Production 11029 12/31/2021
1343 Unit Production 18554 11/30/2021
1343 Unit Production 10503 10/31/2021
Community ChampionAnonymous Please refer the attached file.
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.
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?