Measure ignores date filter.

[A_a_a]

Hi All,

I have two measures [A] and [B]. 

When I put measures: [A],[B],[A]-[B] to Matrix Table, all works properly with date as Column Headers and the output changes correctly when I change the date in the slicer.

But when I want to use: Divide([A],[B],0)-1,the matrix table shows all Dates with correct output for filtered Dates and -100% for others.

Not sure why the matrix table cannot show only filtered Dates in Matrix Table for the last measure.

Please help,

G.

[FreemanZ]

hi @A_a_a 

dates in matrix header, slicer and measures, are they from.the same table?

[A_a_a]

Hi @FreemanZ 

Measures [A] and [B] are from different tables, Date is from dim table, but all is connected by relationships.