Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |