Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

New column conditional

Hi all, I want to a new column with Profile Total only when Product Type = Profile, and GB Total only when Product Type = Storage. Does anyone know how I would do this in the context of the table bel...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago
    Profile Total = IF([Product Type] = "Profile",[Quantity] * 1000,BLANK())

    GB Total = IF([Product Type] = "Storage",[Quantity],BLANK())
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

Try creating a measure like:

 

Measure = CALCULATE(SUM(Quantity); ProductType = "Profile")

Measure = CALCULATE(SUM(Quantity); ProductType = "Storage")

 

Ricardo