Forum Discussion

MCLHRSM's avatar
MCLHRSM
Frequent Visitor
1 year ago

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 show...
"DAX Commands and Tips"
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

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))

MCLHRSM's avatar
MCLHRSM
Frequent Visitor
1 year ago

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?