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 each booking to the respective warehouse. Do i need to create a new column? what do i need?
TY!
5 Replies
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.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.
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
