Forum Discussion

A_a_a's avatar
A_a_a
Helper III
3 years ago

Measure ignores date filter.

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.

 

 

 

2 Replies

  • hi A_a_a 

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

    • A_a_a's avatar
      A_a_a
      Helper III

      Hi FreemanZ 

       

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