The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Solved! Go to 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/
@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/
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
94 | |
85 | |
69 | |
65 |
User | Count |
---|---|
244 | |
128 | |
119 | |
82 | |
78 |