Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculate ranks dynamically based on Slicer

Hi There,   Currently I'm attempting to calculate a starting value based on range of data ranked containing goods issues and goods receipts by date. The problem I have is that my measure isn't work...
Need Help
Show and Tell
nickchobotar's avatar
nickchobotar
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

Anonymous

 

 

Please share your data model and meanwhile you can test this measure. Make sure you have a relationship between zMaterialWarehouseStockMovementQueryPBI table and Data table.

 

 

CALCULATE (
    SUM ( zMaterialWarehouseStockMovementQueryPBI[QuantityReceipts] ),
    FIRSTNONBLANK (
        'Date'[Date],
        CALCULATE (
            SUM ( Inventory[UnitsBalance] ),
            zMaterialWarehouseStockMovementQueryPBI[StockMovementCategory]= "Goods Receipts",
            zMaterialWarehouseStockMovementQueryPBI[StockMovementCategory] = "Goods Issues"
        )
    )
)

 

N -

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

My data model consists of a single table (HANA view), where I connect to using DirectQuery. I don't have a date table but simply a date column with posting dates.