problem with share calculating

[saris02]

Hi!

I'm building a report on a PBI desktop sheet, 3 charts are needed: 1 for segment, 1 for manufacturer & 1 for brand share - at first all calculated from total sales, and then we can select just 1 segment and see the shares for manufacturers & brands in the selected segment.

My problem is, that there are around 100 brands alltogether, too much to show on a graph, so I put on a filter to only show the top 10. If I calculate the share from all products, then unfortunately the segment filter does not impact this calculation - share will be shown always from total category. And if I create a calculation that calculates the share from the selected products, then the calculation will take the top 10 BRN and the selected segment as total category.

Could someone please help how could I calculate share from a segment (all brands included), but still only show top 10 brands?

Many thanks in advance!

[v-danhe-msft]

Hi @saris02,

Could you please offer me some sample data and your desired result or share the pbix if possible?

Regards,

Daniel He

[TomMartens]

Hey,

without some sample data and your measures it's difficult to provide some proper guidance.

But maybe you might consider separate Dimension/Lookup tables for Manufacturer and Brand (Product)

then using ALLSELECTED('ProductTable') might be of some help.

Regard,

Tom