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

Calculated column, distinct value based on filter

I'm not sure what the best method of solving my need here is, hence my question. 

I have a table with events for cases, so each case can have multiple rows, depending on the events that happen. 

I'm trying to find a way where I can catch the cases which don't have one or two specific event codes, and where the "case closed" date column is not blank (meaning case closed) 

 

I've tried making a calculated column but I'm not getting the desired results. 

 

The result I want is the column to tell me if the case meets the above requirements or not.

For example: a "true" if a specific case nr doesn't have one or the other of the event codes, and the date column not blank. Meaning all rows for the case nr should have this true or false

0 REPLIES 0

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.