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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
reynaldo_malave
Helper III
Helper III

filter context issue

Hi guys,

 

I am having he  following problem. I have 2 fact tables sales and goals. The objective is to measure the gap (Brecha Brick) between the sales(MTD) and goals (Metas) this has been done using sumx in both tables and then substracting sales-goals. I have a matrix which is filter by all negative gaps (which represent all products that did not meet the goal) giving me back all results according to plan. Problem arises when trying to filter a card visual by the same negative goals. 

 

Matrix 

reynaldo_malave_0-1602621004688.png

 

Matrix filter context (less than)

 

reynaldo_malave_1-1602621277697.png

If i use a card visual and then apply the same filter context it just doesnt work. It returns all sales within the given period.

 

Any help would be appreciated.

 

Thanks,

 

Rey

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors