Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

% row total as measure

Hi everyone,

 

I know that there is a way to display the % of row total. The problem is that I have to compare the % row total of a table with values of another table...so I think I have to create a measure to calculate the % of row total. Do you know how can I do this?

 

Thanks in advance

Need Help

3 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

     

    I created a sample as below, and add the measures:

    Measure = DIVIDE(MAX(Table1[Volume]),CALCULATE(SUM(Table1[Volume]),ALL(Table1)))
Measure 2 = DIVIDE(MAX(Table2[Volume]),CALCULATE(SUM(Table2[Volume]),ALL(Table2)))
Compariance = [Measure]-[Measure 2]

    Note that there’re one-to-one relationship between 2 tables. Results shown as below:

    Please let us know more details if the issue still pending.

     

    Best regards,

    Dina Ye

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi v-diye-msft ,

      The formula that you wrote is not the percentage of the row but the percentage of the column. 

      Thank you anyway

      • v-diye-msft's avatar
        v-diye-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous ，

         

        I can barely replicate your question, could you please show me your dummy pbix? I'd like to provide the further advice.

         

        Best regards,

        Dina Ye