Multi Tables filter

[Anonymous]

Hi, I'm looking fo a way to solve this little issue. 

I have two tables (strategy and price) linked to a third one (category). 

I want to get a table on my report of : The average of amount by date and by strategy (look at the picture it will be easier to understand).

I have one amount by month.

Thanks !

The tables : 

Price

-    date Amount -   Amount -   idCategory -   idPrice

Category

-          idStrategy -      idCategory

Strategy

-     name of Strategy -       idStrategy

Want I want to get :

Strategy	Price average
A	158
B	598
C	456

Date slicer : 12/05/2019

Thanks for your help !

[Washivale · Accepted solution]

Hello @Anonymous ,

Create relationship between tables using Manage relationship.

Category[idCategory] to Price[IdCategory]

Category[idStrategy] to Strategy[idStrategy]

[Washivale · Accepted solution]

Hello @Anonymous ,

Create relationship between tables using Manage relationship.

Category[idCategory] to Price[IdCategory]

Category[idStrategy] to Strategy[idStrategy]

[Anonymous]

Hi @Washivale ,

It's already done, i'm just trying to find out how to code my dax measure to get the average of Amount by strategy for each dates. 

Thanks for your answer

[Washivale · Accepted solution]

Hi @Anonymous,

Created below using quick measures, check if it helps

idPrice average per Date =

AVERAGEX(

    KEEPFILTERS(VALUES('Price'[Date])),

    CALCULATE(SUM('Price'[Amount]))

)

[Anonymous]

Thanks @Washivale , your dax code resolves my issue ! 

Thanks for the time you gave me !

[Washivale]

Glad that worked!