https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3733654#M145513 <P>This is giving me blanks. Please advise on something else&nbsp;</P> Thu, 29 Feb 2024 13:33:14 GMT SuprajaChennuru 2024-02-29T13:33:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3731173#M145406 <P>I have a matrix visual with 4 levels and the total row should show percentage Average of Score</P><P>&nbsp;</P><P>Calculations Used :</P><P>1. DIV = Quantity/Target Quantity</P><P>2. Score = if DIV &gt;1 then 1 else DIV</P><P>3. Score % = % of Score&nbsp;</P><P>&nbsp;</P><P>I have used the AverageX&nbsp; and AverageX with HASONE functions, but, my results do not work with neither of them.&nbsp;&nbsp;</P><P>&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 28 Feb 2024 16:19:52 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3731173#M145406 SuprajaChennuru 2024-02-28T16:19:52Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3731291#M145416 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="503004" data-lia-user-login="SuprajaChennuru" class="lia-mention lia-mention-user">SuprajaChennuru</a>&nbsp;</P><P>&nbsp;</P><P>Since it appears that you are doiing your division at a row level, I decided to create a calculated column and then find an average of that.</P><P>&nbsp;</P><P>Calculated Column</P><LI-CODE lang="markup">_DIV = VAR _Div = DIVIDE( [Quantity], [Target Quantity] ) VAR _Logic = IF( _Div &gt; 1, 1, _Div ) RETURN _Logic</LI-CODE><P>&nbsp;</P><P>Measure</P><LI-CODE lang="markup">DIV = AVERAGE( Table1[_DIV] )</LI-CODE><P>&nbsp;</P><P>Let me know if you have any questions.</P><P>&nbsp;</P><P><A href="https://1drv.ms/u/s!AnF6rI36HAVkhYUSJ5Htbu6o_ZbJeg?e=dlmPZy" target="_blank">To get average in the Total row instead of sum.pbix</A></P><P>&nbsp;</P> Wed, 28 Feb 2024 17:28:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3731291#M145416 gmsamborn 2024-02-28T17:28:23Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3733654#M145513 <P>This is giving me blanks. Please advise on something else&nbsp;</P> Thu, 29 Feb 2024 13:33:14 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3733654#M145513 SuprajaChennuru 2024-02-29T13:33:14Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3734217#M145542 <P>Can you create a <STRONG>pbix</STRONG> for me to work with?</P><P>&nbsp;</P><P>1)&nbsp; Please provide sample data that covers your issue or question <STRONG>completely</STRONG>.<BR /><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank" rel="noopener">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...</A></P><P>&nbsp;</P><P>2) Please show the <STRONG>expected outcome</STRONG> based on the sample data you provided.<BR /><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank" rel="noopener">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P><P>&nbsp;</P><P>3) Please <STRONG>explain</STRONG> how you would expect to get from step 1 to 2.</P><P>&nbsp;</P><P>4) If possible, please show your past attempts at a solution.</P><P>&nbsp;</P><P>&nbsp;</P><P>I hope this helps.</P> Thu, 29 Feb 2024 17:11:28 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/To-get-average-in-the-Total-row-instead-of-sum/m-p/3734217#M145542 gmsamborn 2024-02-29T17:11:28Z