Filter/remove filters not working
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!