Forum Discussion

Anonymous's avatar
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 b...
Need Help
  • Washivale's avatar
    Washivale
    7 years ago

    Hello Anonymous ,

     

    Create relationship between tables using Manage relationship.

     

    Category[idCategory] to Price[IdCategory]

    Category[idStrategy] to Strategy[idStrategy]

     

  • Washivale's avatar
    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]))
    )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks Washivale , your dax code resolves my issue ! 

 

Thanks for the time you gave me !

Washivale's avatar
Washivale
Resolver V
7 years ago

Glad that worked!