new measure with new filter but with no page filter

[Anonymous]

I want to create a DAX measure that base on specific filters but remove specific page filter

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

For your description, my suggestion could be to use functions such as all, alexcept, etc. In the test below, remove the external filter and keep only the selected filter of calendar year.

M1_ =
CALCULATE (
    SUM ( 'Table'[Quantity] ),
    ALLEXCEPT ( 'Table', 'Table'[Calendar Year] )
)

M2_ =
CALCULATE (
    SUM ( 'Table'[Quantity] ),
    FILTER (
        ALL ( 'Table' ),
        MAX ( 'Table'[Calendar Year] ) = 'Table'[Calendar Year]
    )
)

For more details, you can read related blog as below:

How to use ALL and ALLEXCEPT Functions in Power BI DAX | Microsoft Power BI Kingdom (excelkingdom.blogspot.com)

The (ALL, ALLSELECTED & ALLEXCEPT) Code - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Try all(Table[Column]) or   Removefilters(Table[Column])  in a measure and check

[Anonymous]

CALCULATE(DISTINCTCOUNT(factCyclesStatus[cycle_id]),FILTER(factCyclesStatus,factCyclesStatus[new_status]="pending"),FILTER(dimCycleDate,dimCycleDate[total_seconds]>0),REMOVEFILTERS(dimCycleDate,dimCycleDate[cycle_date]))

its not working together ( filter and remove filters)