topic Re: Divide rows for the corresponding aggregate in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1201295#M19210 If you want to remove filters then use REMOVEFILTERS, can you show what your data looks like? Sat, 04 Jul 2020 09:57:02 GMT AntrikshSharma 2020-07-04T09:57:02Z Divide rows for the corresponding aggregate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1200809#M19184 <P>Hi, I'm a newbie at DAX...<BR />So far I've managed my reports in Power BI with exel and vlookup calculations only... but they're exonerating!!<BR />I would like to go one step beyond writing my formulas not in excel but directly in BI.</P><P>&nbsp;</P><P>I have a series of <STRONG>stores</STRONG> with their own<STRONG> reference clusters</STRONG> and I calculate <STRONG>sales average</STRONG> per Cluster (I managed it with a quick measure) Now I should divide the sales of the room by its average...<BR />I tried Calculate but I don't have to apply a single filter I need all the clusters.</P><P>Thanks !!</P><P>&nbsp;</P> Wed, 08 Jul 2020 08:31:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1200809#M19184 Anonymous 2020-07-08T08:31:53Z Re: Divide rows for the corresponding aggregate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1201295#M19210 If you want to remove filters then use REMOVEFILTERS, can you show what your data looks like? Sat, 04 Jul 2020 09:57:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1201295#M19210 AntrikshSharma 2020-07-04T09:57:02Z Re: Divide rows for the corresponding aggregate https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1204629#M19350 <P>Hi thanks for the answer...</P><P>I will try to explain better. I ha ve two tabs</P><P>tab 1</P><TABLE><TBODY><TR><TD>Id Code</TD><TD>Cluster&nbsp;</TD><TD>Value</TD></TR><TR><TD>1</TD><TD>A</TD><TD>4</TD></TR><TR><TD>2</TD><TD>B</TD><TD>20</TD></TR><TR><TD>3</TD><TD>D</TD><TD>10</TD></TR><TR><TD>4</TD><TD>C</TD><TD>8</TD></TR><TR><TD>5</TD><TD>A</TD><TD>9</TD></TR><TR><TD>6</TD><TD>A</TD><TD>15</TD></TR><TR><TD>7</TD><TD>C</TD><TD>7</TD></TR><TR><TD>8</TD><TD>B</TD><TD>2</TD></TR></TBODY></TABLE><P>and I computed in tab 2&nbsp; the aggragate average for custer ( as pivot excel with field average).</P><P>Now I would obtaina&nbsp; in tab 2 le value ove cluster and than divide the value for its average, in this way</P><TABLE><TBODY><TR><TD>Id Code</TD><TD>Cluster&nbsp;</TD><TD>value</TD><TD>Average</TD><TD>Norm</TD></TR><TR><TD>1</TD><TD>A</TD><TD>4</TD><TD>9</TD><TD>0,4</TD></TR><TR><TD>2</TD><TD>B</TD><TD>20</TD><TD>21</TD><TD>1,0</TD></TR><TR><TD>3</TD><TD>D</TD><TD>10</TD><TD>10</TD><TD>1,0</TD></TR><TR><TD>4</TD><TD>C</TD><TD>8</TD><TD>8</TD><TD>1,1</TD></TR><TR><TD>5</TD><TD>A</TD><TD>9</TD><TD>9</TD><TD>1,0</TD></TR><TR><TD>6</TD><TD>A</TD><TD>15</TD><TD>9</TD><TD>1,6</TD></TR><TR><TD>7</TD><TD>C</TD><TD>7</TD><TD>8</TD><TD>0,9</TD></TR><TR><TD>8</TD><TD>B</TD><TD>22</TD><TD>21</TD><TD>1,0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How I can implement in DAX?</P> Mon, 06 Jul 2020 19:56:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Divide-rows-for-the-corresponding-aggregate/m-p/1204629#M19350 Anonymous 2020-07-06T19:56:15Z