https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2925148#M96064 <P><img /></P><P>I would like to make a measurement that makes the sum for each column marked in the red frame divided by the sum of the values ​​in the column marked in green, except when there is a value equal to 0 in the column in red and at the end add all the values.</P> Wed, 23 Nov 2022 17:55:06 GMT gelsonwj 2022-11-23T17:55:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2925148#M96064 <P><img /></P><P>I would like to make a measurement that makes the sum for each column marked in the red frame divided by the sum of the values ​​in the column marked in green, except when there is a value equal to 0 in the column in red and at the end add all the values.</P> Wed, 23 Nov 2022 17:55:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2925148#M96064 gelsonwj 2022-11-23T17:55:06Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2925706#M96094 <P>this is not a simple logic. could you also provide your expected result, to avoid guesses and trials?</P> Thu, 24 Nov 2022 02:20:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2925706#M96094 FreemanZ 2022-11-24T02:20:08Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2927705#M96246 <P>I managed to solve the problem with the following code&nbsp;</P><P><img /></P><P>&nbsp;</P> Thu, 24 Nov 2022 17:36:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/how-to-make-a-measure-that-makes-the-calculation-based-on/m-p/2927705#M96246 gelsonwj 2022-11-24T17:36:08Z