Forum Discussion

AlexXandyr's avatar
AlexXandyr
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamic measure with date slicers

Hello,  I have encountered a problem with my report. Im trying to show some KPIs for couple different warehouses where I base it on some variable cost and fixed variables with possibility to use a m...
Need Help
  • AlexXandyr's avatar
    AlexXandyr
    2 years ago

    I found a solution where I fixed the Cost for Storage part (making it an average based on the chosen month slicer), which then made the Cost per SQM calculation correct

    Cost per Storage=
    VAR _countofselmonth =
        CALCULATE ( DISTINCTCOUNT ( 'Calendar'[MonthName] ), ALLSELECTED ( 'Calendar' ) )
        RETURN
        DIVIDE (CALCULATE(sum(Actuals[Amount]),Actuals[Cost type] ="Cost for Storage"),  _countofselmonth )
AlexXandyr's avatar
AlexXandyr
Icon for Helper I rankHelper I
2 years ago

I found a solution where I fixed the Cost for Storage part (making it an average based on the chosen month slicer), which then made the Cost per SQM calculation correct

Cost per Storage=
VAR _countofselmonth =
    CALCULATE ( DISTINCTCOUNT ( 'Calendar'[MonthName] ), ALLSELECTED ( 'Calendar' ) )
    RETURN
    DIVIDE (CALCULATE(sum(Actuals[Amount]),Actuals[Cost type] ="Cost for Storage"),  _countofselmonth )