Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to calculate multiples tables?

Hi,   I'm building a financial report where I have a table with the Spread Rate per client and another table with all the sales informations (amount, date, cost, etc).   In my dashboard I need a ...
Need Help
  • v-yingjl's avatar
    v-yingjl
    4 years ago

    Hi Anonymous ,

    You can create this DAX measure to calcualte and use a slicer to filter its value by client:

    Geomertic average = SUM('Sales Table'[Amount]) * SUM('Table'[Spread Rate])

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi Anonymous ,

You can create this DAX measure to calcualte and use a slicer to filter its value by client:

Geomertic average = SUM('Sales Table'[Amount]) * SUM('Table'[Spread Rate])

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.