Forum Discussion
Remove redundant data
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
Community Supporthi 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