topic Re: COUNT VALUE BASED ON OTHER TABLE in DAX Commands and Tips

COUNT VALUE BASED ON OTHER TABLE

Wicak — Tue, 08 Mar 2022 08:35:23 GMT

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 😊

Re: COUNT VALUE BASED ON OTHER TABLE

BeaBF — Tue, 08 Mar 2022 10:01:16 GMT

Wicak Hi!

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

Re: COUNT VALUE BASED ON OTHER TABLE

amitchandak — Tue, 08 Mar 2022 10:07:59 GMT

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

Re: COUNT VALUE BASED ON OTHER TABLE

v-yalanwu-msft — Fri, 11 Mar 2022 06:42:59 GMT

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.

Re: COUNT VALUE BASED ON OTHER TABLE

Wicak — Thu, 17 Mar 2022 09:45:05 GMT

thanks for your sharing 😊