Calculating top product per row in a Table Chart where fields come from different table sources

[Anonymous]

Hi all,

I'm trying to product a table chart like this where I show each station, the total sales for the station and the top selling product and top vehicle customer for that station. However my current code shows a table where the sales is calculated correctly but the top product and top vehicle is wrong. Im guessing it's not calculating the top product and vehicle per row but across all stations since it's showing the same values for each row.

The fields used in the table come from different table sources since I'm following the star schema. Transactions is the fact table while the rest are dimension tables

For example, i'd get the Station Name from the Stations table while Total Sales form the Transactions table.

My current code for identifying the Top Product is

TopProduct = FIRSTNONBLANK(
    TOPN(
        1, VALUES(
            'Vehicles'[VehicleName]
        )
    ),
        SUM('Transactions'[SalesAmount])
)

Would really appreciate help on how to get the correct Top Vehicle and Product. Thank you!

[Anonymous]

Thank you for this, but it unfortunately doesn't solve my issue 

[Padycosmos]

Hope this video helps:

https://www.youtube.com/watch?v=tS1ff6ouORg