Forum Discussion
Remove redundant data
HI I have made a matrix with drill down. I dont want name (Navn) and the budget amount to be showed again when I drill down. How is it possible to fix that? Thank you BR Rune
hi Anonymous
If name (Navn) and the budget amount are in the Value of matrix visual, If so, you could use ISINSCOPE Function to create a IF measure to get it.
See more details, you could refer to this:
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
or
https://xxlbi.com/blog/new-dax-function-isinscope/
If you still have problem, please share your simple sample pbix file for us.
Regards,
Lin
Pragati11
Super User
Super UserHi Anonymous ,
Move your columns "Navn" and "Budget Amount" to ROWS section on this matrix. Then drill-down to lowest hierarchy.
You will get something similar to what you currently have for 1st Column in your matrix "Kudenr..".
Thanks,
Pragati