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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AndreiK15
Helper II
Helper II

Wrong Sales values when apply Filters on this visual

Hello,

 

I need to get known losses (%), but if I set Filters on this Visual for Known Losses Amt AY to “is not blank”, I get a wrong result.

Without Filters on this Visual I get the following:

AndreiK15_0-1638779112460.png

 

 

All figures are correct, the only issue is that it returns all blanks rows because there is a value in Target column.

 

If I set Filters on this Visual for Known Losses Amt AY or any other Losses Column to “is not blank” it will return all losses (correct values), but it will return wrong values for sales (will return only sales for those articles with losses).

 

AndreiK15_1-1638779112464.png

 

 

I need to return sales values like in the first picture when apply Filters on this Visual, but need to keep figures just for Level 1 and total for Store (Store – 69.597, PROASPETE – 27.871 and so on… ).

 

I have tried all filter functions so far, but something’s wrong … relationships between tables are correct.

 

Please help!!!

 

Thank you!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AndreiK15 , you applied a measure filter or a column filter. Column filter can remove row-level data , Measure filter will remove visual level data.

I think in this case you need a measure filter at visual level

View solution in original post

3 REPLIES 3
AndreiK15
Helper II
Helper II

I have created a new measure for target (%) and target (val) column with a filter and works fine now. I wasn't paid attention to that at the moment. Thanks for opening my eyes 🙂 

AndreiK15
Helper II
Helper II

I believe it's a column measure since it was added on Filters on this viasual...

 

AndreiK15_0-1638786394247.png

 

amitchandak
Super User
Super User

@AndreiK15 , you applied a measure filter or a column filter. Column filter can remove row-level data , Measure filter will remove visual level data.

I think in this case you need a measure filter at visual level

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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