1:N results showing "#MULTIVALUE"

Hello, i'm currently pulling data from 2 different queries as shown in image. I've merged the common dimension ([Material]) and created a detail for [Location] using [Material] as associate dimension. I've already read some questions with the same problem but didn't understood the answers, can any

one help me out?