Filter/remove filters not working

MCLHRSM — Fri, 29 Nov 2024 17:48:02 GMT

I have a table from which I want to drill-trough to the details.

The table shows financial transactions (bookings) which are flagged as a risk.

In the table, not all financial bookings will be shown. However, once I select the booking_id to drill-through, I want all bookings with the same booking_id to be shown (all bookings on all GL-accounts with the same booking_id).

I have following measure:

Saldo (all) =

CALCULATE([Saldo],

REMOVEFILTERS(DIM_Klasses_MAR_2),

REMOVEFILTERS(DIM_Klasses_MAR_3),

REMOVEFILTERS(DIM_Journal_Index),

REMOVEFILTERS(FACT_GL[Keyword_Flag]))

This works. Other possible filters on the report page are ignored for the drill through, and all bookings with the booking_id are shown.
I don't want the REMOVEFILTERS(FACT_GL[Keyword_Flag])) to refer to a single column, as other filters from this table can be applied in the future.
If I change the removefilters to the FACT_GL table, and add other rules such as:

Saldo (all) TEST =
CALCULATE(
[Saldo],
REMOVEFILTERS(DIM_Klasses_MAR_2),
REMOVEFILTERS(DIM_Klasses_MAR_3),
REMOVEFILTERS(DIM_Journal_Index),
REMOVEFILTERS(FACT_GL),
-- Use ALLEXCEPT to remove all filters from FACT_GL except for Boeking_ID
ALLEXCEPT(FACT_GL, FACT_GL[Boeking_ID]))

or

Saldo (all) TEST =
CALCULATE(
[Saldo],
REMOVEFILTERS(DIM_Klasses_MAR_2),
REMOVEFILTERS(DIM_Klasses_MAR_3),
REMOVEFILTERS(DIM_Journal_Index),
REMOVEFILTERS(FACT_GL),
-- Explicitly ensure the context for Boeking_ID is preserved
FACT_GL[Boeking_ID] = SELECTEDVALUE(FACT_GL[Boeking_ID])
)

the row level context no longer works. The total is returned for each row, and not the individual booking values.
Any ideas?

Thanks!

Re: Filter/remove filters not working

FreemanZ — Fri, 29 Nov 2024 18:48:25 GMT

hi MCLHRSM ,

try like:

Saldo (all) =

CALCULATE([Saldo],

REMOVEFILTERS(DIM_Klasses_MAR_2),

REMOVEFILTERS(DIM_Klasses_MAR_3),

REMOVEFILTERS(DIM_Journal_Index),

ALLSELECTED(FACT_GL))

Re: Filter/remove filters not working

MCLHRSM — Mon, 02 Dec 2024 07:46:09 GMT

Hello,

In this case, the correct rows are shown (indicating the filters work correctly).

However, the values for each row show the total value (in this case 0, as it are financial transactions in which debet=credit).

Any ideas?

topic Re: Filter/remove filters not working in DAX Commands and Tips

Filter/remove filters not working

Re: Filter/remove filters not working

Re: Filter/remove filters not working