i want to create a measure to calculate sales of all the competitors available in same category and

[Suraj46b]

i want to create a measure to calculate sales of all the competitors of a brand, competitors should be available in the same category and subcategory as the brand selected and the market should be only those markets where the brand has sales available for selected corporations for example doliprane is available in pain care and cough and cold category and body pain and mutli pain subcatgeory and it has sales available only in brazil and india so i want to look into all the competitor brand which are in pain care and cough and cold category and body pain and mutli pain subcatgeory and market should be only India and brazil

[FreemanZ]

seems doable, but only after you providing some sample data