Power BI - multiple table lookup and count

[Ucubia]

Hi,


I have two tables Hosts (Excel), and Applications (SQL) within a Power BI desktop - this being the customer's preferred choice.

"Hosts" contains a list of unique server platforms being used, for the purposes of this thread the range being Server001-Server100
"Applications" contains a list of applications and the platform they reside upon, therefore there could be a single application upon a dedicated server, or there could be multiple applications sharing a server - for example

Application001 Server001
Application002 Server001
Application002 Server002
Application003 Server003
Application004 Server004
Application005 Server004
Application006 Server004

Ideally, want to add a column to identify the number of application each server to associated to, thus the output being:

Server001 2
Server002 1
Server003 1
Server004 3

I am stuck and struggling to understand the easiest method to calculate the information when using multiple tables - I thought COUNTROWS might be the answer but to get the count would essentially mean I have to filter for each individual server which for the example would be challenging 1-100 but in reality the host list runs into multiple '00s

Any help gratefully received, as I am still familiarising with Power BI

Many thanks, Ian

 

[Fluff]

Duplicate to: Multi table lookup and count

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.