Forum Discussion

sreyes10's avatar
sreyes10
Helper 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
Community 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
Helper 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.

 

 

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    7 years ago

    sreyes10  if you can share your data i can see what i can do

     

     

      • vanessafvg's avatar
        vanessafvg
        Community Champion
        7 years ago

        sreyes10  would you filter on the date in a slicer?  if so you can use this

         

        % of Total2 = CALCULATE(DIVIDE(sum(Query1[Value]), CALCULATE(sum(Query1[Value]), ALLSELECTED(Query1))))