https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Custom-Rounding/m-p/2989185#M938 <P>This one came out of this thread:&nbsp;<A href="https://community.powerbi.com/t5/Desktop/How-to-do-custom-rounding-in-DAX/m-p/2988669" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-do-custom-rounding-in-DAX/m-p/2988669</A>. Basically, how to do custom rounding such that:</P> <UL> <LI>Round all numbers down</LI> <LI>Compute the number of digits missing from 100 after rounding (99, 98, etc.)&nbsp;</LI> <LI>Round up the highest decimal places in order to ensure 100 total</LI> </UL> <P>This was the result.&nbsp;</P> <LI-CODE lang="markup">Rounding = VAR __Cat2 = MAX('Table'[Category2]) VAR __Table = GENERATE( SUMMARIZE( FILTER(ALLSELECTED('Table'), [Category2] = __Cat2), 'Table'[Category1],'Table'[Category2],"Value",MAX([Percentage])), VAR __Value = [Value] VAR __RD = ROUNDDOWN(__Value,0) VAR __Decimal = __Value - __RD RETURN ROW( "RD", __RD, "Decimal", __Decimal ) ) VAR __MaxDecimal = MAXX(__Table,[Decimal]) VAR __MaxCategory = MAXX(FILTER(__Table, [Decimal] = __MaxDecimal),[Category1]) VAR __2ndMaxDecimal = MAXX(FILTER(__Table, [Category1] &lt;&gt; __MaxCategory), [Decimal]) VAR __2ndMaxCategory = MAXX(FILTER(__Table, [Category1] &lt;&gt; __MaxCategory &amp;&amp; [Decimal] = __2ndMaxDecimal),[Category1]) VAR __Category = MAX('Table'[Category1]) VAR __SumDown = SUMX(__Table, [RD]) VAR __Result = SWITCH(__SumDown, 99, IF( __Category = __MaxCategory, ROUNDUP(MAX([Percentage]),0), ROUNDDOWN(MAX([Percentage]),0) ), 98, IF( __Category = __MaxCategory || __Category = __2ndMaxCategory, ROUNDUP(MAX([Percentage]),0), ROUNDDOWN(MAX([Percentage]),0) ) ) RETURN __Result</LI-CODE> <P><SPAN class="reportid hidden">eyJrIjoiOGYyMTRmZDUtMmNmOC00ZjdmLTg1NzYtMzczMjMyMDYzYjQyIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Mon, 26 Dec 2022 19:26:42 GMT Greg_Deckler 2022-12-26T19:26:42Z https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Custom-Rounding/m-p/2989185#M938 <P>This one came out of this thread:&nbsp;<A href="https://community.powerbi.com/t5/Desktop/How-to-do-custom-rounding-in-DAX/m-p/2988669" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-do-custom-rounding-in-DAX/m-p/2988669</A>. Basically, how to do custom rounding such that:</P> <UL> <LI>Round all numbers down</LI> <LI>Compute the number of digits missing from 100 after rounding (99, 98, etc.)&nbsp;</LI> <LI>Round up the highest decimal places in order to ensure 100 total</LI> </UL> <P>This was the result.&nbsp;</P> <LI-CODE lang="markup">Rounding = VAR __Cat2 = MAX('Table'[Category2]) VAR __Table = GENERATE( SUMMARIZE( FILTER(ALLSELECTED('Table'), [Category2] = __Cat2), 'Table'[Category1],'Table'[Category2],"Value",MAX([Percentage])), VAR __Value = [Value] VAR __RD = ROUNDDOWN(__Value,0) VAR __Decimal = __Value - __RD RETURN ROW( "RD", __RD, "Decimal", __Decimal ) ) VAR __MaxDecimal = MAXX(__Table,[Decimal]) VAR __MaxCategory = MAXX(FILTER(__Table, [Decimal] = __MaxDecimal),[Category1]) VAR __2ndMaxDecimal = MAXX(FILTER(__Table, [Category1] &lt;&gt; __MaxCategory), [Decimal]) VAR __2ndMaxCategory = MAXX(FILTER(__Table, [Category1] &lt;&gt; __MaxCategory &amp;&amp; [Decimal] = __2ndMaxDecimal),[Category1]) VAR __Category = MAX('Table'[Category1]) VAR __SumDown = SUMX(__Table, [RD]) VAR __Result = SWITCH(__SumDown, 99, IF( __Category = __MaxCategory, ROUNDUP(MAX([Percentage]),0), ROUNDDOWN(MAX([Percentage]),0) ), 98, IF( __Category = __MaxCategory || __Category = __2ndMaxCategory, ROUNDUP(MAX([Percentage]),0), ROUNDDOWN(MAX([Percentage]),0) ) ) RETURN __Result</LI-CODE> <P><SPAN class="reportid hidden">eyJrIjoiOGYyMTRmZDUtMmNmOC00ZjdmLTg1NzYtMzczMjMyMDYzYjQyIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9</SPAN></P> Mon, 26 Dec 2022 19:26:42 GMT https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Custom-Rounding/m-p/2989185#M938 Greg_Deckler 2022-12-26T19:26:42Z