Measure not filtering with slicer all other measure filter

[Anonymous]

Hi Expert

All my mesure filter expect for one and i cannot see the wood for the trees. I have two tables in my model a FACT tables - table A and a Dim_Date Table - Table B 

Table B (DATE) links to Table A  (Created Date)

measure

Previous Period B/f =

VAR MinDate = MIN('STG Dim_Date'[FirstDayOfMonth])

VAR MaxDate = MAX('STG Dim_Date'[FirstDayOfMonth])

VAR LastWeek = MAX('STG Dim_Date'[LastDayOfMonth])

RETURN

CALCULATE(SUM('Table A'[Closed]),

FILTER(ALLEXCEPT('Table A','Table A'[Full_Name]),

'Table A'[Created_Date] < MinDate &&

'Table A'[Date_Closed] >= MaxDate && 'Table A'[Date_Closed] <= LastWeek && 'Table A'[Created_Date]<>BLANK()))

[Pragati11]

Hi @Anonymous ,

You will have add more detail here like screesnhots on what is not filtering.

You haven't mentioned - what slicer you are using and what is not filtering.

Just posting the measure firmula is not helping much.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati

[Syndicate_Admin]

Sorry i cannot upload from my laptop??? otherwise i would have provided an image.

[Anonymous · Accepted solution]

Hi All

I found the solution applied another filter based on the team.

CALCULATE(SUM('Tabla A'[Cerrado]),

FILTER(ALLEXCEPT('Tabla A','Tabla A'[Full_Name], 'Table A 'Teams]),

'Tabla A'[Created_Date] < MinDate &&

'Tabla A'[Date_Closed] >-MaxDate && 'Tabla A'[Date_Closed] <' LastWeek && 'Tabla A'[Created_Date]<>BLANK())

This gave the correct answer. Thanks Experts