Forum Discussion

SzymonKl's avatar
SzymonKl
Helper I
2 years ago

measure

 Hi All    Can you please help me create a measure please :  Currently my stock balance ( measure [Processed Stock] for asset type [ASSET_TYPE_ID] = 128 is 1323, for asset type [ASSET_TYPE_ID] = 1...
Need Help
MFelix's avatar
MFelix
Super User
2 years ago

Hi SzymonKl ,

 

This is very generic however you can try something similar to this:

Stock Revised =
IF (
    SELECTEDVALUE ( 'Table'[ASSET_TYPE_ID] ) = 128,
    SUM ( 'Table'[Stock] )
        - SUMX (
            FILTER ( ALL ( 'Table' ), 'Table'[ASSET_TYPE_ID] <> 128 ),
            'Table'[Stock]
        ),
    SUM ( 'Table'[Stock] )
)

 

SzymonKl's avatar
SzymonKl
Helper I
2 years ago

Hi Miguel

Unfortunately, this is not working. 

'Table'[Stock]

 is a measure not column, and the data is connected via direct query 

  • MFelix's avatar
    MFelix
    Super User
    2 years ago

    Hi SzymonKl ,

     

    If this is a measure then just replace the column by the measure:

    Stock Revised =
IF (
    SELECTEDVALUE ( 'Table'[ASSET_TYPE_ID] ) = 128,
    [Stock] 
        - SUMX (
            FILTER ( ALL ( 'Table' ), 'Table'[ASSET_TYPE_ID] <> 128 ),
            [Stock]
        ),
[Stock]
)