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 r...
General Comment
Need Help
Show and Tell
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