Forum Discussion

Ste4en's avatar
Ste4en
Frequent Visitor
3 years ago
Solved

Filter in a Measure

I have a list of running hours for a piece of equipment for every period/week. I use the following Measure to generate a cummulitive running hour curve: CummulitiveMHbyPeriod = CALCULATE(     SUM...
Need Help
  • Ste4en's avatar
    Ste4en
    3 years ago

    SOLUTION FROM ChatCPT in case anyone sees this.

     

    CumulativeMH_EquipA =
    CALCULATE(
    SUM('Distribution'[Period Values]),
    FILTER(
    ALLSELECTED('Distribution'[Dates]),
    ISONORAFTER('Distribution'[Dates], MAX('Distribution'[Dates]), DESC)
    ),
    'Distribution'[EquipmentType] = "EquipA"
    )

Ste4en's avatar
Ste4en
Frequent Visitor
3 years ago

SOLUTION FROM ChatCPT in case anyone sees this.

 

CumulativeMH_EquipA =
CALCULATE(
SUM('Distribution'[Period Values]),
FILTER(
ALLSELECTED('Distribution'[Dates]),
ISONORAFTER('Distribution'[Dates], MAX('Distribution'[Dates]), DESC)
),
'Distribution'[EquipmentType] = "EquipA"
)