Forum Discussion
A_a_a
3 years agoHelper III
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.