% row total as measure

[Anonymous]

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

[v-diye-msft]

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]

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]

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