Matrix issue in power bu

[siddharthShi]

Hi ,

I have a requirement where in I have some sponsors and security mapping, one sponsor is linked with many securities.I used a matrix approach where I have Sponsor at level one then Security at level 2 and COunt in Values section.

Now i have used maximum on the count field.

So when I collapse Blackstone it will display 3 next to it in count column (which is working as expected) but when i expand  and show the underlying securities (3 securities) I dont want to show that count next to each security but only at Blackstone levele.

Is there a way to achive this?

[amitchandak · Accepted solution]

@siddharthShi , I think isinscope can help

example

If(isinscope(Table[Security]), blank(), [meausre])

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/