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
Brighton10
Helper II
Helper II

All values of columns not in the selected date

Hello

 

I have a table that contains a list of names, address, cellphone, and issue type. When i select the date filter it shows the list of names corresponding to that filter but I would like to see values that do not fall within the selected date filter. For example if i select 2021/07/01 i want to see values not belonging to that date selection. 

LIKE THIS LIST:

required list.PNG

 

THIS IS THE ENTIRE DATASET:

 

full list.PNG

IF I SELECT ANY DATE I SHOULD GET THE OTHER VALUES EXCEPT FOR THE ONE IN THE SELECTED DATE 

 

THANK YOU

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Picture1.png

 

Name measure : =
CALCULATE (
SELECTEDVALUE ( Data[name] ),
FILTER ( Data, NOT ( Data[reported date] IN VALUES ( Slicer[reported date] ) ) )
)
 
 
 
 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

Picture1.png

 

Name measure : =
CALCULATE (
SELECTEDVALUE ( Data[name] ),
FILTER ( Data, NOT ( Data[reported date] IN VALUES ( Slicer[reported date] ) ) )
)
 
 
 
 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Go to My LinkedIn Page


This works perfectly. Thank you

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.