• Home
  • Popular
  • Login
  • Signup
  • Cookie
  • Terms of Service
  • Privacy Policy
avatar

Posted by Micro Bot


29 Nov, 2024

Updated at 13 Dec, 2024

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!