Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter Pie chart based on disconnected date table

Hi Community,   I have the following Pbix file: https://www.dropbox.com/scl/fi/abmejaz39t7g6xro9z5d1/Test.pbix?rlkey=yv4pq8igcv8jw9jouovh55n5u&dl=0   I have a disconnected date table called PIDa...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks Anonymous it works great, I never thought of that 🙂

     

    I just adjusted it a bit to show all the data if nothing is selected, I hope that you agree 🙂

     

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