Filter in a Measure

[Ste4en]

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('Distribution'[Period Values]),

    FILTER(

        ALLSELECTED('Distribution'[Dates]),

        ISONORAFTER('Distribution'[Dates], MAX('Distribution'[Dates]), DESC)

)

I now have two pieces of equipment in the same list and I want a seperate cummultive curve for each piece. I tried to edit the same measure above but add a filter to only select the records for EquipA; and then copy it and edit it to select EquipB. I need to see both together on one axis so a slicer or visual filter which shows one at a time doesnt work . How can i achieve this.

Thanks

[Ste4en · Accepted solution]

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

[Ritaf1983]

Hi @Ste4en 

Please see the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Count-Accumulate-by-brand-with-slicer-Year-and-Mon...

if your scenario is different 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly