cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GatorTB
New Member

Multiple records with same id but must filter out just the 1 matching row based on criteria.

I need to create a new report using this sample list below. 

power bi snippet.JPG

Each CID has 4 possible SignOffs. CID 5000 shows all SignOff options.

 

For the same CIDs, show me the ones that have a record for SBSLA while also NOT having a record for SBSUPPORTBETA or SBFUNCTIONALITYBETA.  So, I don't want to see CID 5000, nor CID 3144.  I do want to see 4461.

Your help is appreciated!

1 ACCEPTED SOLUTION
jdbuchanan71
Super User II
Super User II

@GatorTB 

I think this will give you what you are looking for.

Filter Measure = 
VAR _SBSLA = CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Signoff] = "SBSLA" )
VAR _OTHER = CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Signoff] IN {"SBFUNCTIONALITYBETA","SBSUPPORTBETA"} )
RETURN 
IF ( AND ( _SBSLA <> 0, _OTHER = 0 ), "Show" )

jdbuchanan71_0-1614834247419.png

 

View solution in original post

2 REPLIES 2
jdbuchanan71
Super User II
Super User II

@GatorTB 

I think this will give you what you are looking for.

Filter Measure = 
VAR _SBSLA = CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Signoff] = "SBSLA" )
VAR _OTHER = CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[Signoff] IN {"SBFUNCTIONALITYBETA","SBSUPPORTBETA"} )
RETURN 
IF ( AND ( _SBSLA <> 0, _OTHER = 0 ), "Show" )

jdbuchanan71_0-1614834247419.png

 

View solution in original post

Thank you!  That worked perfectly!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors