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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.