Forum Discussion

Kolumam's avatar
Kolumam
Post Prodigy
7 years ago

Filtering Issues based on Country

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] )
            )
        )
    )
)
General Comment
Need Help
Show and Tell

2 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    7 years ago
    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
  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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