Filter Pie chart based on disconnected date table

Hi Anonymous ,

Consider creating a virtual table and using it to iteratively sum.
For example:

Skipped 2 = 
SUMX (
    FILTER (
        SUMMARIZE (
            'Fact',
            'Fact'[tsexecutionid],
            "filtervalue", [IsActiveMeasure],
            "skipped", SUM ( 'Fact'[skipped] )
        ),
        [filtervalue] = 1
    ),
    [skipped]
)

Output:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum