Forum Discussion
Matrix issue in power bu
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?
Anonymous , 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/
1 Reply
- amitchandak
Super User
Anonymous , 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/