https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replace-calculated-Column-with-calculated-Measure-with-if/m-p/3772018#M147368 <P>Good day, hope you can help me with the following.<BR />I'm having probles updating my PBI, i'm getting the "not enough memory" while updating, form everything i have read it has to do with a few calculted columns i have added to a table, let call it C. Now i´m trying to replace the calculated columns with calculated measures but i'm not getting the result i need.<BR />I have a table A that has the columns Date, Year, Month, Hour, Unit, Generation, I have a table B that has the columns Date, Year, Month, Hour, Unit, Generation, the same as table A, and I have a Table C that has the columns Date, Year, Month, Unit, Generation and type of remuneration, I want to make a calculated measure in table C , I want the measure to take the average of the generation column of table A and Table B but that takes the average of one or the other depending on the value of the Remuneration Type column of Table C, the Remuneration Type column is of type text, how can i do this?<BR />thanks in advance</P> Mon, 18 Mar 2024 15:05:47 GMT jr10 2024-03-18T15:05:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replace-calculated-Column-with-calculated-Measure-with-if/m-p/3772018#M147368 <P>Good day, hope you can help me with the following.<BR />I'm having probles updating my PBI, i'm getting the "not enough memory" while updating, form everything i have read it has to do with a few calculted columns i have added to a table, let call it C. Now i´m trying to replace the calculated columns with calculated measures but i'm not getting the result i need.<BR />I have a table A that has the columns Date, Year, Month, Hour, Unit, Generation, I have a table B that has the columns Date, Year, Month, Hour, Unit, Generation, the same as table A, and I have a Table C that has the columns Date, Year, Month, Unit, Generation and type of remuneration, I want to make a calculated measure in table C , I want the measure to take the average of the generation column of table A and Table B but that takes the average of one or the other depending on the value of the Remuneration Type column of Table C, the Remuneration Type column is of type text, how can i do this?<BR />thanks in advance</P> Mon, 18 Mar 2024 15:05:47 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replace-calculated-Column-with-calculated-Measure-with-if/m-p/3772018#M147368 jr10 2024-03-18T15:05:47Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replace-calculated-Column-with-calculated-Measure-with-if/m-p/3772648#M147414 <P>Before you do that ask yourself - can the result be impacted by users interacting with your reports?&nbsp; If the answer is no, and the data is immutable, then you should not use a measure. If a calculated column is too slow or consumes too much memory then either optimize its code, or push it upstream and create that column in Power Query.</P> <P>&nbsp;</P> <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Mon, 18 Mar 2024 21:57:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Replace-calculated-Column-with-calculated-Measure-with-if/m-p/3772648#M147414 lbendlin 2024-03-18T21:57:17Z