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 ...
Need Help
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