Forum Discussion
Help creating formula
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 ...
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.
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.