https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/i-want-to-create-a-measure-to-calculate-sales-of-all-the/m-p/3213053#M117241 <P>seems doable, but only after you providing some sample data</P> Mon, 01 May 2023 00:11:26 GMT FreemanZ 2023-05-01T00:11:26Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/i-want-to-create-a-measure-to-calculate-sales-of-all-the/m-p/3212431#M117198 <P><SPAN>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 </SPAN></P> Sat, 29 Apr 2023 20:38:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/i-want-to-create-a-measure-to-calculate-sales-of-all-the/m-p/3212431#M117198 Suraj46b 2023-04-29T20:38:45Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/i-want-to-create-a-measure-to-calculate-sales-of-all-the/m-p/3213053#M117241 <P>seems doable, but only after you providing some sample data</P> Mon, 01 May 2023 00:11:26 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/i-want-to-create-a-measure-to-calculate-sales-of-all-the/m-p/3213053#M117241 FreemanZ 2023-05-01T00:11:26Z