Add same value into multiple "data groups"

[Daniel23]

Hi,

I have a case, where I need to add values from a dimension table column into multiple data groups. The built-in funtion for this in Power BI does not seem to support this (you can only add 1 value into 1 group). Is there a workaround ?

I have tried to illustrate what i am trying to do:

[RafaelRSantosBR]

@Ahmed do you still have the file?

[Ahmedx]

Sample PBIX file attached

[Ahmedx]

Do you need it?

[Daniel23]

@Ahmedx Yes! How? 

[Ahmedx · Accepted solution]

look at the file

https://dropmefiles.com/vJND9

[Daniel23]

@Ahmedx Thank you, it makes sense!
I ended up without a relation of the new table you created to the fact table. I dont have column in fact table with group, this exists only in dimension. But your approach works anyway.

[amitchandak]

@Daniel23 , Create a new column 

Type = Switch(True() ,

[Group] in {"A", "B"} , "Prod" ,

"Serv"

)

Add that into column on Matrix visual along with group

[Daniel23]

Hi @amitchandak ,

Thanks for the suggestion. I dont understand how this will work though. If I add to columns in Matrix visual along with another, f.x. the group, the matrix visual will create a hierarchy display. I want to flatten it so that it is shown on the same row.