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
3 Replies
Hi 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
Anonymous . First column value is different that is why it is showing
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
