topic Re: Need help with a partitioned sum slicer that updates based on other slicer selections in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2922591#M95883 <P>Also I can create a measure that gets me the data results I need just can't use a measure in a slicer.</P> Tue, 22 Nov 2022 19:42:53 GMT plutoforever 2022-11-22T19:42:53Z Need help with a partitioned sum slicer that updates based on other slicer selections https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2916646#M95526 <P>I am not sure why this is such a struggle for me to figure out but I have a product gallons detail table with these 5 columns:&nbsp;</P><P><img /></P><P>And 4 slicers:&nbsp;</P><P><img /></P><P>Sales Volume in the table is broken out by Account #, G/L Date and Product Type however Summed by Account # is a calculated column partitioned just by Account #:&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">Summed by Account # = CALCULATE( SUM('Gallons Purchased Details'[Sales Volume]), FILTER( 'Gallons Purchased Details', 'Gallons Purchased Details'[Account #]= EARLIER('Gallons Purchased Details'[Account #]) ) )</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>The problem is being a calculated column it doesn't update on slicer selections and I need it to for the Summef by Account # slicer.&nbsp; For example, for the last 12 months the total Sales Volume for Account # 519981 is 1,105.00 and for 3818608 it's 1,531.00:&nbsp;<img /></P><P>&nbsp;</P><P>Which is what shows in the slicer:&nbsp;<img /></P><P>&nbsp;</P><P>However, say the G/L Date Slicer is changed to this:&nbsp;</P><P>&nbsp;<img /></P><P>I would want the Summed by Account # slicer to update and show a minimum of 800.00 and maximum of 1,084.00&nbsp;<img /></P><P>&nbsp;<img /></P><P>The end result being so the user can only show accounts that have bought a certain amount of product over a specific date range and/or product type.</P><P>&nbsp;</P><P>This is the raw data:&nbsp;</P><TABLE border="1"><TBODY><TR><TD><P>Account #</P></TD><TD><P>Sales Volume</P></TD><TD><P>G/L Date</P></TD><TD><P>Product Type</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>7</P></TD><TD><P>12/28/2021</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>12/29/2021</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>6</P></TD><TD><P>1/3/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>1/4/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>1/6/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>21</P></TD><TD><P>1/10/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>1/12/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>1/16/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>1/18/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>40</P></TD><TD><P>1/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>1/31/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>2/2/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>9</P></TD><TD><P>2/4/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>2/8/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>2/13/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>2/20/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>7</P></TD><TD><P>2/23/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>2/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>30</P></TD><TD><P>3/2/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>3/6/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>3/9/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>13</P></TD><TD><P>3/12/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>3/18/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>3/21/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>3/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>28</P></TD><TD><P>3/27/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>25</P></TD><TD><P>3/30/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>19</P></TD><TD><P>4/3/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>4/4/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>4/5/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>4/7/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>11</P></TD><TD><P>4/10/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>27</P></TD><TD><P>4/14/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>20</P></TD><TD><P>4/18/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>13</P></TD><TD><P>4/20/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>4/21/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>7</P></TD><TD><P>4/24/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>4/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>4/29/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>4/30/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>5</P></TD><TD><P>5/4/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>36</P></TD><TD><P>5/6/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>5/8/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>5/9/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>5/12/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>28</P></TD><TD><P>5/17/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>5/22/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>5/23/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>12</P></TD><TD><P>5/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>48</P></TD><TD><P>5/29/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>41</P></TD><TD><P>6/5/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>22</P></TD><TD><P>6/8/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>6/16/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>36</P></TD><TD><P>6/17/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>13</P></TD><TD><P>6/20/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>9</P></TD><TD><P>6/21/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>6/24/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>6/26/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>6/29/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>7/2/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>7/3/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>6</P></TD><TD><P>7/4/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>4</P></TD><TD><P>7/5/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>13</P></TD><TD><P>7/5/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>34</P></TD><TD><P>7/10/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>7/17/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>7/20/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>8</P></TD><TD><P>7/24/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>22</P></TD><TD><P>7/26/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>30</P></TD><TD><P>7/31/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>9</P></TD><TD><P>8/2/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>8/7/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>8/13/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>11</P></TD><TD><P>8/16/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>20</P></TD><TD><P>8/25/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>8/31/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>9/4/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>16</P></TD><TD><P>9/9/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>8</P></TD><TD><P>9/11/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>13</P></TD><TD><P>9/13/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>22</P></TD><TD><P>9/18/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>21</P></TD><TD><P>9/28/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>4</P></TD><TD><P>10/2/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>10</P></TD><TD><P>10/3/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>17</P></TD><TD><P>10/6/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>28</P></TD><TD><P>10/9/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>10/14/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>20</P></TD><TD><P>10/22/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>10/23/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>11</P></TD><TD><P>10/28/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>15</P></TD><TD><P>10/31/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>11</P></TD><TD><P>11/4/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>11/13/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>3818608</P></TD><TD><P>14</P></TD><TD><P>11/16/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>100</P></TD><TD><P>1/4/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>108</P></TD><TD><P>2/24/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>97</P></TD><TD><P>2/24/2022</P></TD><TD><P>Gas</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>274</P></TD><TD><P>6/16/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>298</P></TD><TD><P>8/29/2022</P></TD><TD><P>Diesel</P></TD></TR><TR><TD><P>519981</P></TD><TD><P>228</P></TD><TD><P>11/16/2022</P></TD><TD><P>Diesel</P></TD></TR></TBODY></TABLE> Tue, 22 Nov 2022 19:40:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2916646#M95526 plutoforever 2022-11-22T19:40:05Z Re: Need help with a partitioned sum slicer that updates based on other slicer selections https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2922591#M95883 <P>Also I can create a measure that gets me the data results I need just can't use a measure in a slicer.</P> Tue, 22 Nov 2022 19:42:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2922591#M95883 plutoforever 2022-11-22T19:42:53Z Re: Need help with a partitioned sum slicer that updates based on other slicer selections https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2922905#M95909 <P>Calculated column/table is not supposed to respond to the slicer or any other filtering action in Report view.</P><P>&nbsp;</P><P><A href="https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculated-columns-and-slicer-value/m-p/2265418" target="_blank">https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculated-columns-and-slicer-value/m-p/2265418</A></P> Wed, 23 Nov 2022 00:15:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2922905#M95909 FreemanZ 2022-11-23T00:15:17Z Re: Need help with a partitioned sum slicer that updates based on other slicer selections https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2930855#M96417 <P>Yeah I know a calculated column can't update which I'm trying to find an alternate solution.&nbsp; I followed your link but am struggling to apply the solutions there to what I am needing.&nbsp; The end result is a measure and I can't use that in a measure.&nbsp;</P><P>&nbsp;</P><P>I am needing an end result where the user can slice by sales volume only after G/L Date/Product Type are selected. So for example: 1) Let them show all customers who purchased at least 200 gallons of Propane in the past calendar year or 2) Let them show all customers who purchased 200 gallons of all products for last month.&nbsp; So I need to start with the product and date details so the user can slice by them but then end with a total sum slicer once the selections have been.</P> Sat, 26 Nov 2022 21:32:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-help-with-a-partitioned-sum-slicer-that-updates-based-on/m-p/2930855#M96417 plutoforever 2022-11-26T21:32:51Z