topic Re: to display different Levels in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754839#M146500 <P>&nbsp;</P><TABLE><TBODY><TR><TD>CHANNEL</TD><TD>Realigned SPGR</TD><TD>Exit Status</TD><TD>BGR</TD><TD>Period</TD><TD>Sales</TD><TD>TAE</TD></TR><TR><TD>CPC</TD><TD>80052</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 684</TD><TD>459.9288</TD></TR><TR><TD>CPC</TD><TD>80102</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,860</TD><TD>5854.837</TD></TR><TR><TD>CPC</TD><TD>80130</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,428</TD><TD>6664.999</TD></TR><TR><TD>CPC</TD><TD>80201</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,376</TD><TD>3394.397</TD></TR><TR><TD>CPC</TD><TD>80204</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,020</TD><TD>282.973</TD></TR><TR><TD>CPC</TD><TD>80205</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240</TD><TD>685.9039</TD></TR><TR><TD>CPC</TD><TD>80702</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</TD><TD>84.60612</TD></TR><TR><TD>CPC</TD><TD>80789</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 264</TD><TD>51.25488</TD></TR><TR><TD>CPC</TD><TD>81067</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240</TD><TD>299.7073</TD></TR><TR><TD>CPC</TD><TD>81600</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 648</TD><TD>989.8885</TD></TR><TR><TD>CPC</TD><TD>81601</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 508</TD><TD>583.988</TD></TR><TR><TD>CPC</TD><TD>81779</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,584</TD><TD>845.0919</TD></TR><TR><TD>CPC</TD><TD>83731</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,008</TD><TD>130.712</TD></TR><TR><TD>CPC</TD><TD>83842</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,268</TD><TD>1742.348</TD></TR><TR><TD>CPC</TD><TD>83846</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 684</TD><TD>37.17978</TD></TR><TR><TD>CPC</TD><TD>84045</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>413.1129</TD></TR><TR><TD>CPC</TD><TD>87400</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,620</TD><TD>528.7976</TD></TR><TR><TD>CPC</TD><TD>87414</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>30.77008</TD></TR><TR><TD>CPC</TD><TD>87416</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</TD><TD>140.8703</TD></TR><TR><TD>CPC</TD><TD>87430</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 168</TD><TD>110.3145</TD></TR><TR><TD>CPC</TD><TD>87440</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>101.5637</TD></TR><TR><TD>CPC</TD><TD>87449</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 144</TD><TD>78.89207</TD></TR><TR><TD>CPC</TD><TD>88330</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48</TD><TD>16.19855</TD></TR><TR><TD>CPC</TD><TD>88835</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 384</TD><TD>964.6944</TD></TR><TR><TD>CPC</TD><TD>88868</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 960</TD><TD>441.7013</TD></TR><TR><TD>CPC</TD><TD>89054</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD><TD>1387.534</TD></TR><TR><TD>CPC</TD><TD>89059</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,160</TD><TD>6458.904</TD></TR><TR><TD>CPC</TD><TD>89135</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 936</TD><TD>510.7398</TD></TR><TR><TD>CSD</TD><TD>80052</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 13,560</TD><TD>3907.867</TD></TR><TR><TD>CSD</TD><TD>80102</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 58,320</TD><TD>20499.05</TD></TR><TR><TD>CSD</TD><TD>80130</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 67,872</TD><TD>29312.13</TD></TR><TR><TD>CSD</TD><TD>80132</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 37,320</TD><TD>14972.39</TD></TR><TR><TD>CSD</TD><TD>80201</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;1,02,942</TD><TD>4958.114</TD></TR><TR><TD>CSD</TD><TD>80789</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,188</TD><TD>221.9304</TD></TR><TR><TD>CSD</TD><TD>80892</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,320</TD><TD>346.727</TD></TR><TR><TD>CSD</TD><TD>81067</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,244</TD><TD>542.2157</TD></TR><TR><TD>CSD</TD><TD>81600</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 26,460</TD><TD>2595.27</TD></TR><TR><TD>CSD</TD><TD>81601</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 18,000</TD><TD>13809.92</TD></TR><TR><TD>CSD</TD><TD>83731</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 23,400</TD><TD>1991.73</TD></TR><TR><TD>CSD</TD><TD>84045</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,048</TD><TD>470.2744</TD></TR><TR><TD>CSD</TD><TD>85738</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 39,672</TD><TD>2304</TD></TR><TR><TD>CSD</TD><TD>87400</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 23,904</TD><TD>6468.342</TD></TR><TR><TD>CSD</TD><TD>89050</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 51,376</TD><TD>15091.01</TD></TR><TR><TD>CSD</TD><TD>89059</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;1,20,096</TD><TD>11237.57</TD></TR></TBODY></TABLE> Mon, 11 Mar 2024 10:52:50 GMT tkavitha911 2024-03-11T10:52:50Z to display different Levels https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754830#M146499 <P><SPAN>I want to visualize the hierarchical levels of the data using a matrix visual, displaying Channel level percentage, SPGR level percentage, and BGR level percentage based on the SFA%.<BR /></SPAN>SFA = IF(TAE&gt;=SALES,0,1-(TAE/SALES))</P> Mon, 11 Mar 2024 10:44:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754830#M146499 tkavitha911 2024-03-11T10:44:17Z Re: to display different Levels https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754839#M146500 <P>&nbsp;</P><TABLE><TBODY><TR><TD>CHANNEL</TD><TD>Realigned SPGR</TD><TD>Exit Status</TD><TD>BGR</TD><TD>Period</TD><TD>Sales</TD><TD>TAE</TD></TR><TR><TD>CPC</TD><TD>80052</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 684</TD><TD>459.9288</TD></TR><TR><TD>CPC</TD><TD>80102</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,860</TD><TD>5854.837</TD></TR><TR><TD>CPC</TD><TD>80130</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4,428</TD><TD>6664.999</TD></TR><TR><TD>CPC</TD><TD>80201</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,376</TD><TD>3394.397</TD></TR><TR><TD>CPC</TD><TD>80204</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,020</TD><TD>282.973</TD></TR><TR><TD>CPC</TD><TD>80205</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240</TD><TD>685.9039</TD></TR><TR><TD>CPC</TD><TD>80702</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 120</TD><TD>84.60612</TD></TR><TR><TD>CPC</TD><TD>80789</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 264</TD><TD>51.25488</TD></TR><TR><TD>CPC</TD><TD>81067</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 240</TD><TD>299.7073</TD></TR><TR><TD>CPC</TD><TD>81600</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 648</TD><TD>989.8885</TD></TR><TR><TD>CPC</TD><TD>81601</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 508</TD><TD>583.988</TD></TR><TR><TD>CPC</TD><TD>81779</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,584</TD><TD>845.0919</TD></TR><TR><TD>CPC</TD><TD>83731</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,008</TD><TD>130.712</TD></TR><TR><TD>CPC</TD><TD>83842</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2,268</TD><TD>1742.348</TD></TR><TR><TD>CPC</TD><TD>83846</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 684</TD><TD>37.17978</TD></TR><TR><TD>CPC</TD><TD>84045</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>413.1129</TD></TR><TR><TD>CPC</TD><TD>87400</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1,620</TD><TD>528.7976</TD></TR><TR><TD>CPC</TD><TD>87414</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>30.77008</TD></TR><TR><TD>CPC</TD><TD>87416</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</TD><TD>140.8703</TD></TR><TR><TD>CPC</TD><TD>87430</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 168</TD><TD>110.3145</TD></TR><TR><TD>CPC</TD><TD>87440</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96</TD><TD>101.5637</TD></TR><TR><TD>CPC</TD><TD>87449</TD><TD>Active</TD><TD>FACE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 144</TD><TD>78.89207</TD></TR><TR><TD>CPC</TD><TD>88330</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48</TD><TD>16.19855</TD></TR><TR><TD>CPC</TD><TD>88835</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 384</TD><TD>964.6944</TD></TR><TR><TD>CPC</TD><TD>88868</TD><TD>Active</TD><TD>NM FACE - CLEANSING</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 960</TD><TD>441.7013</TD></TR><TR><TD>CPC</TD><TD>89054</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5,000</TD><TD>1387.534</TD></TR><TR><TD>CPC</TD><TD>89059</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,160</TD><TD>6458.904</TD></TR><TR><TD>CPC</TD><TD>89135</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 936</TD><TD>510.7398</TD></TR><TR><TD>CSD</TD><TD>80052</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 13,560</TD><TD>3907.867</TD></TR><TR><TD>CSD</TD><TD>80102</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 58,320</TD><TD>20499.05</TD></TR><TR><TD>CSD</TD><TD>80130</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 67,872</TD><TD>29312.13</TD></TR><TR><TD>CSD</TD><TD>80132</TD><TD>Active</TD><TD>CREMES</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 37,320</TD><TD>14972.39</TD></TR><TR><TD>CSD</TD><TD>80201</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;1,02,942</TD><TD>4958.114</TD></TR><TR><TD>CSD</TD><TD>80789</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,188</TD><TD>221.9304</TD></TR><TR><TD>CSD</TD><TD>80892</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7,320</TD><TD>346.727</TD></TR><TR><TD>CSD</TD><TD>81067</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8,244</TD><TD>542.2157</TD></TR><TR><TD>CSD</TD><TD>81600</TD><TD>Active</TD><TD>DEO MALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 26,460</TD><TD>2595.27</TD></TR><TR><TD>CSD</TD><TD>81601</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 18,000</TD><TD>13809.92</TD></TR><TR><TD>CSD</TD><TD>83731</TD><TD>Active</TD><TD>DEO FEMALE</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 23,400</TD><TD>1991.73</TD></TR><TR><TD>CSD</TD><TD>84045</TD><TD>Active</TD><TD>SHOWER</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9,048</TD><TD>470.2744</TD></TR><TR><TD>CSD</TD><TD>85738</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 39,672</TD><TD>2304</TD></TR><TR><TD>CSD</TD><TD>87400</TD><TD>Active</TD><TD>BODY</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 23,904</TD><TD>6468.342</TD></TR><TR><TD>CSD</TD><TD>89050</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;&nbsp;&nbsp; 51,376</TD><TD>15091.01</TD></TR><TR><TD>CSD</TD><TD>89059</TD><TD>Active</TD><TD>SOFT</TD><TD>202401</TD><TD>&nbsp;1,20,096</TD><TD>11237.57</TD></TR></TBODY></TABLE> Mon, 11 Mar 2024 10:52:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754839#M146500 tkavitha911 2024-03-11T10:52:50Z Re: to display different Levels https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754870#M146501 <P><img /></P><P>this is out put for the sfa% in excel i want to diplay in power bi using SFA calculation&nbsp;</P> Mon, 11 Mar 2024 11:02:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3754870#M146501 tkavitha911 2024-03-11T11:02:02Z Re: to display different Levels https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3756635#M146563 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="672212" data-lia-user-login="tkavitha911" class="lia-mention lia-mention-user">tkavitha911</a>&nbsp;,</P> <P>&nbsp;</P> <P>According to your description, here are my steps you can follow as a solution.</P> <P>(1) My test data is the same as yours.</P> <P>(2) We can create a measure.&nbsp;</P> <P><img /></P> <LI-CODE lang="markup">SFA % = IF(SUM('Table'[TAE])&gt;=SUM('Table'[Sales]),0,1-DIVIDE(SUM([TAE]),SUM([Sales])))</LI-CODE> <P>(3) Then the result is as follows.</P> <P><img /></P> <P>Best Regards,</P> <P>Neeko Tang</P> <P>If this post  <STRONG><EM>helps</EM></STRONG>, then please consider <STRONG><EM>Accept it as the solution </EM></STRONG> to help the other members find it more quickly.&nbsp;</P> Tue, 12 Mar 2024 02:15:25 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/to-display-different-Levels/m-p/3756635#M146563 Anonymous 2024-03-12T02:15:25Z