Absolute Total regardless of unrelated fields

[MADSS]

Hi guys, 

Self taught PBI user here. 

I'm currently suck on a calculation, which I was hoping to get your advice on. 

I have 3 different tables. 

Table 1 - Stock

Table 2 - Customers

Table 3 - Warehouses

I have "Warehouses" as a midway link to "Stock" and "Customers"

The Customers table contains customer information, eg - their region. 

The Stock table contains current stock holding information, eg - warehouse

The warehouses table is a simple conversion between customer region - "EUR" for our warehouses in that region "EU"/"UK", etc. 

I am trying to build a visual table, which shows - customer name, what they've purchased, and how much stock is available for that customers region, as a total. 

Because customers don't "hold" any stock to their name - it errors out. 

Is there a way for me to calculate the total stock for that region, based on the customers region, but not taking into account the actual customers name?

Thanks

[Anonymous]

Hi @MADSS ,

It's hard to reproduce the scenario. Please take a look at this topic about How-to-Get-Your-Question-Answered-Quickly .

I tried creating a demo according to your description. If you want to get the stock of region for specific customer, you may need to create a relationship between Customers and Warehouses.

If I misunderstood your requirement, please show some sample data and expected result.

Best Regards,
Jay

[amitchandak]

@MADSS , can you share sample data and data model