Isinscope

[nasolme]

Hi Community,

I have a PROJET table related with a CONTRAT table which is related to my TRANCHE table.

1 Projet = many Contrat = 1 contrat = many tranche

when i use this mesure all CONTRAT  appear in all PROJET : 

SIREN = If(ISINSCOPE(CONTRAT[NUMERO CONTRAT]),1,0) 

Do you have an Idea why i have this result ?

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=y2FFjfRD-Bo

[amitchandak]

@nasolme , In matrix the TOP level is always is in scope

if you have dragged COl1, COl2,

Col1 is isisncope in all rows other than total

Col2 is not in scope at subtotal level

refer if needed

IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM