Forum Discussion

sreyes10's avatar
sreyes10
Icon for Helper I rankHelper I
7 years ago

Creating a Sum Measure Conditionally (Revenue vs Another Accounts)

Dear Power BI Experts, I'm trying to create a New Measure where I have a constant value which is the Revenue. My idea is to find what is the percentage of each accounting cell against the Revenue....
Need Help
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
7 years ago

sreyes10  if you trying to get the % you need to divide the amount of a specific account into the total 

 

i dont think i imported in the data correctly but look at my %of total measure to show you what i think you trying to do

 

 

 

  • sreyes10's avatar
    sreyes10
    Icon for Helper I rankHelper I
    7 years ago

    Hello GvA ,

    Thanks for your answer. 

     

    I have tried that formula, but in my data I have the same data replicated for all years, this means that the table is constantly repeated. It means that I have a columns with the period for each one. 

     

    When I used that formula, It took the whole total Revenue of all periods and not the period that I want.