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
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]
)