Forum Discussion

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
7 years ago
Solved

Create a calculation based on two tables

Hello Power Bi Gurus!    Would need your help on something.  I currently have two tables, Revenue Individual (1) and Revenue Collection (2). I need these two tables to create a third table, Revenu...
Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

FuzzyYabs's avatar
FuzzyYabs
Frequent Visitor
7 years ago

Hello v-cherch-msft 

 

Your samples are very helpful. I will look into your suggestions. Thank you so much! 

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi FuzzyYabs 

     

    Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

     

    Regards,

    Cherie