https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-that-specific-row-amount-from-total-amount-from-every/m-p/2545499#M71865 <P>Anonymous</LI-USER>&nbsp;<BR /><BR />Please check the attached file below my signature for the measures<BR /><BR /></P> <P><img /><BR /><BR /></P> <P>&nbsp;</P> Sat, 28 May 2022 19:26:58 GMT Fowmy 2022-05-28T19:26:58Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-that-specific-row-amount-from-total-amount-from-every/m-p/2545476#M71861 <P>Hello Group,</P><P>&nbsp;</P><P>I have an issue where I need to calculate overall profitability impact if I exclude that single product and in Excel it was easy but I need it as a visual in Power BI?</P><P>&nbsp;</P><P>In below screen shot, I need help on DAX on columns highlighted where In if Product A Net revenue is excluded from Total Revenue what would be my impact on overall profitability.</P><P>&nbsp;</P><P>Now I need that for each single row calculation where Prod B,C,D etc excluded and calculate its Impact?</P><P>&nbsp;</P><P>Please help on DAX calcualtion in regards to it?</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Sat, 28 May 2022 18:48:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-that-specific-row-amount-from-total-amount-from-every/m-p/2545476#M71861 Anonymous 2022-05-28T18:48:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-that-specific-row-amount-from-total-amount-from-every/m-p/2545499#M71865 <P>Anonymous</LI-USER>&nbsp;<BR /><BR />Please check the attached file below my signature for the measures<BR /><BR /></P> <P><img /><BR /><BR /></P> <P>&nbsp;</P> Sat, 28 May 2022 19:26:58 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Excluding-that-specific-row-amount-from-total-amount-from-every/m-p/2545499#M71865 Fowmy 2022-05-28T19:26:58Z