Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

Multi Tables filter

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
7 years ago
Hello Anonymous ,

Create relationship between tables using Manage relationship.

Category[idCategory] to Price[IdCategory]
Category[idStrategy] to Strategy[idStrategy]
Washivale
7 years ago
Hi Anonymous,

Created below using quick measures, check if it helps

idPrice average per Date =
AVERAGEX(
KEEPFILTERS(VALUES('Price'[Date])),
CALCULATE(SUM('Price'[Amount]))
)

5 Replies

Washivale
Resolver V
7 years ago
Hello Anonymous ,

Create relationship between tables using Manage relationship.

Category[idCategory] to Price[IdCategory]
Category[idStrategy] to Strategy[idStrategy]
- Anonymous
  Not applicable
  7 years ago
  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
    Resolver V
    7 years ago
    Hi Anonymous,
    
    Created below using quick measures, check if it helps
    
    idPrice average per Date =
    AVERAGEX(
    KEEPFILTERS(VALUES('Price'[Date])),
    CALCULATE(SUM('Price'[Amount]))
    )