New column conditional

Hi Anonymous ,

Try creating a measure like:

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

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

Ricardo

Hi Anonymous 

try columns

Profile Total =
IF(Table[Product Type] = "Profile"), Table[Quantity]*1000, BLANK() )

and

GB Total =
IF(Table[Product Type] = "Storage"), Table[Quantity], BLANK() )

Hi,

Please try these two measures(showing the correct total):

Profile Total =
SUMX (
    GROUPBY ( 'Table', [Product Type], 'Table'[Customer] ),
    CALCULATE (
        IF (
            MAX ( 'Table'[Product Type] ) = "Profile",
            MAX ( 'Table'[Quantity] ) * 1000,
            BLANK ()
        )
    )
)

GB Total =
SUMX (
    GROUPBY ( 'Table', [Product Type], 'Table'[Customer] ),
    CALCULATE (
        IF (
            MAX ( 'Table'[Product Type] ) = "Storage",
            MAX ( 'Table'[Quantity] ),
            BLANK ()
        )
    )
)

The result shows:

Here is my test pbix file:

pbix 

Hope this helps.

Best Regards,

Giotto