Help with CALCULATED MEASURE on selected objects.

[Syndicate_Admin]

Good day friends. I need help with the following problem.

I have a calculated measure ([TOTAL COST]) that is composed of 6 tables (Salaries, Suppliers, Amortizations, etc.) that are all related.

To calculate the value of the hour, I divide that cost by the monthly hours.

I need to show a specific graph for each of the elements that make up the [TOTAL COST], the problem is that when I select one of the elements in that graph, the [TOTAL COST] adds up all the concepts and I just want it to show what is selected.

Could you help me?

Thank you!!

[Syndicate_Admin · Accepted solution]

I was able to solve it using filters. Thanks a lot!

[amitchandak]

@Syndicate_Admin ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.