Forum Discussion
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...
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.
Samarth_18
Community Champion
Community ChampionHI Anonymous ,
Please try this:-
ProdUnits =
IF (
MAX ( Table1[company ID] ) = "1055",
CALCULATE (
SUM ( Table1[count] ) * 0.50,
FILTER ( Table1, Table1[PrdType] = "Unit Production" )
),
CALCULATE (
SUM ( Table1[count] ),
FILTER ( Table1, Table1[PrdType] = "Unit Production" )
)
)
BR,
Samarth
I tried this measure and although I do not get an error message for the measure, I also do not have any values returned either. The measure is completely blank in my visualization.
- Samarth_18
Anonymous Can you please share the sample data in text format with expected output?
It is not allowing me to load a sample data set