Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
A_a_a
Helper III
Helper 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.

 

 

 

2 REPLIES 2
FreemanZ
Super User
Super User

hi @A_a_a 

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

Hi @FreemanZ 

 

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.