Latest Enterprise DNA Initiatives

Matrix levels duplicate values

Hi folks, i have a matrix via a template, when i drill down through the levels of the template i get duplication of values, how can i either make the value blank or stop the matrix from going down levels for all items? See snip below, the red lines are duplicate values of the above which i don’t want, i only want the top line value no matter how many levels i go down, thanks in advance.

Hi @BCS,

Look into the ISINSCOPE function, here’s a link.

https://dax.guide/isinscope/

If you need more assistance, provide a sample PBIX.
I hope this is helpful

Hi @BCS, did the response provided by @Melissa help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!

Hi @BCS, we’ve noticed that no response has been received from you since the 19th of May. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.

Thanks very much @Melissa