Forum Discussion
How to link between two charts?
It was fixed by adding a relationship between the tables with the MES column.
Thank you!
Best regards.
Hi Syndicate_Admin you want the percentage to be based on whatever is currently selected in your report, try this measure
Dynamic Category Percentage =
DIVIDE(
SUM(YourTable[CategoryValue]),
CALCULATE(
SUM(YourTable[CategoryValue]),
ALLSELECTED(YourTable[Category])
)
) * 100I hope this method will work. Let me know your progress. For this case, Its better if you create some sample data like 5-10 records and show case the table relationship and the explain what you want to achieve then its very easy for others to understand and solve the problem.
Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!
Hello! No, I would like the percentage of each one (training, meetings, not charged, suspended, internal activities, rework) with respect to the total amount of billing in the same month.
April Training: 5,187,710
Total turnover April: 78,951,173
Training percentage: 6.75%