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

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
Icon for Resolver V rankResolver 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 !

    • Washivale's avatar
      Washivale
      Icon for Resolver V rankResolver V
      7 years ago

      Glad that worked!