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  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?

     

     

    • vanessafvg's avatar
      vanessafvg
      Community Champion
      7 years ago

      sreyes10  explain to me what you are trying to achieve and maybe i can be more helpful around the actual solution.

       

      What are you trying to do and why sort thing.

      • sreyes10's avatar
        sreyes10
        Helper I
        7 years ago

        Well, 

         

        In summarize, I have financial statements for 15 segments. For those, I have 15 tables connected with date, segment and accounting Name. 

         

        I want to find the percentage of the Xaccount / Total Revenue. In this case, if I want to find it value for period 2018, it takes the sum of the total of XAccount  and the TOTAL REVENUE of each month and get the %. 

         

        Now I have rows that contains the TOTAL REVENUE and I want a constant variable that show me the value of TOTAL REVENUE (SUM), and if I use a filter, it doesn't affect that variable. 

         

        Its clear that explanation?

         

        Thanks in advance for your help!