Fixed count for every row with % ratio

[Anonymous]

Hi community!

I'm working on a problem which I try to ilustrate on below example.

1 is my table. As you can see, I have some people with theri attributes and with business units their belong to (main BU and Sub-BU). What I have now in Power BI i the 2 view. That was quite easy to do. 

But right now, I need implement view 3 and create new column that shows percentage ratio. I need to calculate number of names in BUs and Sub-BUs that will not change regardless of chosen attribute. I've tried different measures but cannot get the right values. 

I will appreciate any guidance.

[amitchandak]

@Anonymous , based on what I got, These two measures can help

countx(filter(allselected(Table), [Business Unit] = max(Table[Business Unit]) ), [Name])

countx(filter(allselected(Table), [Business Unit] = max(Table[Business Unit]) && [Sub BU] = max(Table[Sub BU]) ), [Name])

[Anonymous]

Hi @amitchandak. Thanks for replay. Unfortunately, this solutions solution doesn't resolve my problem. This example I provided is very simplified. In reality my data model is much bigger and columns are in seperate tables. (only BU and SUB-BU are in the same table, Names and Attribute are in seperate ones). Also, it gives me an error as last argument of COUNTX should be an expression and not the column name.