Filtering Issues based on Country

[Kolumam]

Hi All,

I have a measure which is in a table called "Dates". I am not able to filter it by country. The "country" is present in another table called "Opportunities".  They both have an indirect relationship but unable to filter by country.

Dates[Cumulative Size Won] =
CALCULATE (
    SUM ( Project[Size (MWp)] ),
    FILTER (
        ALLEXCEPT ( Project, 'Project Phases'[Phase] ),
        AND (
            Project[Phase]<>"Abandoned",
            AND (
                Project[Phase] <> "LOI",
                Project[PPA Date] <= MAX ( Dates[Last day of month] )
            )
        )
    )
)

[v-juanli-msft]

Hi @Kolumam

What are the relationships amont these tables?

How about this measure:

Dates[Cumulative Size Won] =
CALCULATE (
    SUM ( Project[Size (MWp)] ),
    ALLSELECTED(table[country]),
    FILTER (
        ALLEXCEPT ( Project, Project[Phase] ),
        AND (
            Project[Phase]<>"Abandoned",
            AND (
                Project[Phase] <> "LOI",
                Project[PPA Date] <= MAX ( Dates[Last day of month] )
            )
        )
    )
)

Best Regrads

Maggie

[TomMartens]

Hey, so the issue you are facing is the following: no matter which country you select from a slicer, you always see the same value? Can you please share a screenshot of the relationships, and maybe you also might consider to create sample data, upload the pbix to onedrive or dropbox and share the link. Regards, Tom