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())
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

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