Help creating formula

[170323003]

I want to separate the total of the "bookings id" so i can tell how many of them each "warehouse" have it.

So, i have the bookings Id and i have the "warehouses", but i havent the necessary to link each booking to the respective warehouse. Do i need to create a new column? what do i need? 

TY!

[Icey]

Hi @170323003 ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards,

Icey

[Icey]

Hi @170323003 ,

What's your data structure like? Please share us some sample data and show us the desired result. Please remove sensitive information.

Best Regards,

Icey

[Greg_Deckler]

@170323003 Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[170323003]

Hi,

As u can see, on left i have the bookings id and on right i have the warehouses.

What i want to do, is simply tell how many bookings each warhouse had! For example:

*Those two columns are from different tables.

[Icey]

Hi @170323003 ,

There should be a relationship between the two tables. Then, try to use COUNT or COUNTROWS function.

Measure = COUNT ('Table'[Name])

Measure = COUNTROWS ('Table')

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.