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
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))))
      • sreyes10's avatar
        sreyes10
        Helper I
        7 years ago

        I will filter the period and the account that I want to know the %. 

         

        There is a way to select just the rows "TOTAL REVENUE" and sum them?