Forum Discussion

170323003's avatar
170323003
Helper I
6 years ago

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 ...
General Comment
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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's avatar
170323003
Helper I
6 years ago

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's avatar
    Icey
    Community Support
    6 years ago

    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.