Forum Discussion
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!
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!
2 Replies
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?
