Page level filter limiting visible rows but now total

[abehrmann]

I have a page level filter [status = Open]

and then a certian visual is this mesure below

Closed Week =

CALCULATE (

[WO Count],BI_Orders_DT_View[status (groups)]="Closed",

ALLEXCEPT (

BI_Orders_DT_View,

BI_Orders_DT_View[workmanager],

BI_Clients_DT[Client Team],

BI_Clients_DT[Company],

BI_Clients_DT[Squad],

BI_Orders_DT_View[wodatecompleted],

BI_Orders_DT_View[division (groups)]

),

WEEKNUM ( TODAY (),2 ) = WEEKNUM ( BI_Orders_DT_View[wodatecompleted],2),

YEAR(TODAY()) =YEAR(BI_Orders_DT_View[wodatecompleted])

)

But the page level filter is limiting the names slicing the visual if they do not have anything that is "Open" 

Disregard Closed Week Test as it is what i am using to test with. 

[v-frfei-msft · Accepted solution]

Hi @abehrmann ,

That should be the issue of the Function ALLEXCEPT in your formula. It will remove all context filters in the table except filters that have been applied to the specified columns.