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