Many to many relationship bringing Inflated values in bar chart

[Raveeshlokanath]

How can I count dynamically the repetitions of dimension as shown in arrow so I can divide that for bar chart on selection of dimension so it gives correct values, it is inflating now as cardinality is set to many to many so many times it is counting for caluclation, I can over come this by dividing the cout how many times the dimension values are repeated for caluclation.

Thanks in advance.

[Ritaf1983]

Hi @Raveeshlokanath 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523