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
gianmarco
Helper IV
Helper IV

Advanced filter

Dear All,

I can slice a table for the following row values: 0 1 2 3

 

What I want to achieve is a slicer where I can filter for the following options: 0 & 1, 0 & 2, 0 & 3.

 

In other words, you can slice for 1, 2 & 3 only but when you do you always slice for 0 as well.

 

Thank you very much

gianmarco

2 REPLIES 2
Ahmedx
Super User
Super User

Is this what you are looking for?

total = 
VAR _Valueselect =VALUES('Table'[Value])
VAR _SUM =CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value] in _Valueselect))
VAR _SUMSERO = CALCULATE([sales],FILTER(ALL('Table'),'Table'[Value]=0))
VAR _Rsults = IF({0} in _Valueselect,_SUM,_SUM+_SUMSERO)
RETURN
_Rsults

Dear Ahmedx, not really.

Maybe it's less complicated than this.
Consider I want to filter a table by 4 clients: A, B, C & D.

 

When i filter for Client A, I want to obtain results as I would be filtering for A and D.

When i filter for Client B, I want to obtain results as I would be filtering for B and D

When i filter for Client C, I want to obtain results as I would be filtering for C and D.

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.