stacked bar chart with related tables

[Anonymous]

Hello Community,

I have been trying to create a Bar Chart where i can can Categorize by the Column Material Group. I have to Tables in relation, in the first one Requirements i'm counting the Product Area entrys but those values also have a subcategory in the the table called RequirementsMaterialGroup with the Column Material Group and i need to count by those values which can be multiple (S,P,M,K). Here a visualization:

How should the measure look like to accomplish this?  Or any oter solution.

Edit: I have been trying with this measure which i thought it should work but it doesn't show anything...

Count = CALCULATE(COUNTROWS(RequirementsMaterialGroup);FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="P");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="M");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="K");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="N");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="S");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="H");FILTER(RequirementsMaterialGroup;RequirementsMaterialGroup[Material Group]="O"))

Best regards

domates

[v-chuncz-msft]

@Anonymous,

It seems that you just need to drag [Material Group] to Legend.

[Anonymous · Accepted solution]

Hello @v-chuncz-msft,

i tried this at the very beginning and it's not working.

Best regards and a happy Christmas

Edit: **bleep**, i forgot a letter in the ID and didn't notice that's why it didn't work. Sorry for wasting your time.