topic Issue with DAX Calculation in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Calculation/m-p/4410892#M175167 <P>Hi guys!<BR /><BR />First of all thanks for reading and helping.</P><P>&nbsp;</P><P>Ok, let's suppose i have some price data like this<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Owner</TD><TD>SKU</TD><TD>BRAND</TD><TD>DATE</TD><TD>PRICE</TD><TD>DESC</TD><TD>RETAIL</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>1180</TD><TD>Prod A</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>3273</TD><TD>Prod B</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>644</TD><TD>Prod C</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>683</TD><TD>Prod D</TD><TD>WALMART</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>2154</TD><TD>Prod A</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>1945</TD><TD>Prod B</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>733</TD><TD>Prod C</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>577</TD><TD>Prod D</TD><TD>WALLGREENS</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>1742</TD><TD>Prod A</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>1112</TD><TD>Prod B</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>589</TD><TD>Prod C</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>712</TD><TD>Prod D</TD><TD>TARGET</TD></TR></TBODY></TABLE><P><BR /><BR />What i'm trying to calculate via DAX is a Price Index with this custom formula: (AVG Selling Price of my products / AVG Selling Price of my competence) * 100.</P><P>&nbsp;</P><P>I have so far this two meassures:<BR /><BR />ASP_Compete =<BR />CALCULATE(<BR />[ASP],<BR />'Table'[Owner] = "Competitor"<BR />)<BR /><BR />ASP_Company =<BR />CALCULATE(<BR />[ASP],<BR />'Table'[Owner] = "Company"<BR />)<BR /><BR />And a separate one for the price index wich is:<BR /><BR />Price Index=&nbsp;DIVIDE(ASP_Comp, ASP_Compete) * 100<BR /><BR />From my logic it should work fine, but when i drop into any vissual i got the error: "Error fetching data for this visual: An unexpected exception occurred"<BR /><BR />Do you know if this is related to an issue of Power BI's version?</P><P>&nbsp;</P><P>Thank u again for your answers.</P><P>&nbsp;</P><P>Regards</P> Fri, 14 Feb 2025 10:38:37 GMT ItsMikeBelmont 2025-02-14T10:38:37Z Issue with DAX Calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Calculation/m-p/4410892#M175167 <P>Hi guys!<BR /><BR />First of all thanks for reading and helping.</P><P>&nbsp;</P><P>Ok, let's suppose i have some price data like this<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Owner</TD><TD>SKU</TD><TD>BRAND</TD><TD>DATE</TD><TD>PRICE</TD><TD>DESC</TD><TD>RETAIL</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>1180</TD><TD>Prod A</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>3273</TD><TD>Prod B</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>644</TD><TD>Prod C</TD><TD>WALMART</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>683</TD><TD>Prod D</TD><TD>WALMART</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>2154</TD><TD>Prod A</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>1945</TD><TD>Prod B</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>733</TD><TD>Prod C</TD><TD>WALLGREENS</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>577</TD><TD>Prod D</TD><TD>WALLGREENS</TD></TR><TR><TD>Company</TD><TD>74258323</TD><TD>A</TD><TD>########</TD><TD>1742</TD><TD>Prod A</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>14325325</TD><TD>B</TD><TD>########</TD><TD>1112</TD><TD>Prod B</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>1212434</TD><TD>C</TD><TD>########</TD><TD>589</TD><TD>Prod C</TD><TD>TARGET</TD></TR><TR><TD>Competitor</TD><TD>12145346</TD><TD>D</TD><TD>########</TD><TD>712</TD><TD>Prod D</TD><TD>TARGET</TD></TR></TBODY></TABLE><P><BR /><BR />What i'm trying to calculate via DAX is a Price Index with this custom formula: (AVG Selling Price of my products / AVG Selling Price of my competence) * 100.</P><P>&nbsp;</P><P>I have so far this two meassures:<BR /><BR />ASP_Compete =<BR />CALCULATE(<BR />[ASP],<BR />'Table'[Owner] = "Competitor"<BR />)<BR /><BR />ASP_Company =<BR />CALCULATE(<BR />[ASP],<BR />'Table'[Owner] = "Company"<BR />)<BR /><BR />And a separate one for the price index wich is:<BR /><BR />Price Index=&nbsp;DIVIDE(ASP_Comp, ASP_Compete) * 100<BR /><BR />From my logic it should work fine, but when i drop into any vissual i got the error: "Error fetching data for this visual: An unexpected exception occurred"<BR /><BR />Do you know if this is related to an issue of Power BI's version?</P><P>&nbsp;</P><P>Thank u again for your answers.</P><P>&nbsp;</P><P>Regards</P> Fri, 14 Feb 2025 10:38:37 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Calculation/m-p/4410892#M175167 ItsMikeBelmont 2025-02-14T10:38:37Z Re: Issue with DAX Calculation https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Calculation/m-p/4411005#M175177 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="931819" data-lia-user-login="ItsMikeBelmont" class="lia-mention lia-mention-user">ItsMikeBelmont</a>&nbsp;,</P><P>&nbsp;</P><P>This error comes when you have very large data.</P><P>However, the logic works fine with your sample data</P><P><img /></P><P>&nbsp;</P> Fri, 14 Feb 2025 11:39:45 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Issue-with-DAX-Calculation/m-p/4411005#M175177 Rupak_bi 2025-02-14T11:39:45Z