Forum Discussion

Aikeno's avatar
Aikeno
Helper I
3 years ago

Multicolumns filter

Hello everyone, I have published a report with a matrice of this type (see below):   Project Contact Backup Start End 500 Benoit Jean     600 Jean Fab...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Aikeno You need to use a Complex Selector: The Complex Selector - Microsoft Fabric Community. In your case something like:

Complex Selector Measure = 
  VAR __Target = "Jean"
  VAR __Contact = MAX( 'Table'[Contact] )
  VAR __Backup = MAX( 'Table'[Backup] )
  VAR __Result = IF ( __Contact = __Target || __Backup = __Target, 1, 0 )
RETURN
  __Result
Aikeno's avatar
Aikeno
Helper I
3 years ago

Hello,

 

Sorry for my late answer.

My need is to use a slicer to select the name as shown in your example.

I try to use your example but I think i don't get the good formatting for it.

 

Thanks for your help.