Forum Discussion
Create a calculation based on two tables
Hi FuzzyYabs
Please check the measures in attachment.
AC Power Rate = DIVIDE ( CALCULATE ( SUM ( Individual[Amount] ), Individual[Department] = "AC POWER" ), CALCULATE ( SUM ( Total[Total] ), FILTER ( ALL ( Total ), Total[Department Total] = "AC POWER" && Total[Date] <> "NOV C18" ) ) )Regards,
Cherie
Hi FuzzyYabs
You may just create the measures as below.If it is not your case,please share the .pbix sample file for us to provide an accurate solution.You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
SumRevenueCollection = SUMX('Revenue Collection','Revenue Collection'[Revenue Collection])
Revenue Rate = SUM('Revenue Individual'[Revenue Individual])/[SumRevenueCollection]
Regards,
Cherie
Hello v-cherch-msft ,
here's a Sample file.
There are two datasets. Individual and Total.
The need is to create a third table, which will have the computation as below.
Hi FuzzyYabs
Please check the measures in attachment.
AC Power Rate = DIVIDE ( CALCULATE ( SUM ( Individual[Amount] ), Individual[Department] = "AC POWER" ), CALCULATE ( SUM ( Total[Total] ), FILTER ( ALL ( Total ), Total[Department Total] = "AC POWER" && Total[Date] <> "NOV C18" ) ) )Regards,
Cherie
Almost! haha however, how am I suppose to make the calculation such that the totals will only be for a selected date range? ex. the total should be the sum from Nov 2017 - Oct 2018???
Apologies for having to many questions about this and thank you for helping me on this.
Hi FuzzyYabs
What is a selected date range? You want to add a slicer to get the dynamic date range?If so,you may refer to below post to get the last 12 month values from selected month.
Regards,
Cherie