COUNT VALUE BASED ON OTHER TABLE

[Wicak]

I have Four tables related to name, i want to count names in Table D. i try model measurement but it's so complecated and one by one. is there way to simplfy measurement with DAX or pivot table or other way

please your advice. Thank's  😊  

[BeaBF · Accepted solution]

@Wicak Hi!

I didn't understand, what would be the result you want to achieve? Can you show me?

BF

[v-yalanwu-msft · Accepted solution]

Hi, @Wicak ;

As amitchandak said, you could unpivot in power query first.

1.unpivot three table and select all column.

2.append table.

The final output is shown below:

3.add table in desktop and count of it.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Wicak]

thanks for your sharing 😊

[amitchandak]

@Wicak , Unpivot the first three table to get the name column from member 1, member 2 etc

Then create a common name dimension

Name =distinct(union(distinct(Table1[Name]),distinct(Table2[Name]),distinct(Table3[Name]),distinct(Table3[Name])))

Join it with all four tables and now you can do analysis together

https://radacad.com/pivot-and-unpivot-with-power-bi
Append : https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[BeaBF · Accepted solution]

@Wicak Hi!

I didn't understand, what would be the result you want to achieve? Can you show me?

BF