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

        Thanks Washivale , your dax code resolves my issue ! 

         

        Thanks for the time you gave me !