https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393984#M174443 <P>bingo. Thank you.&nbsp;</P> Tue, 04 Feb 2025 09:31:22 GMT rsch91 2025-02-04T09:31:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393948#M174437 <P>Hi all,</P><P>&nbsp;</P><P>I'm trying to create a calculated table as follows:</P><P>&nbsp;</P><DIV><DIV><EM>&nbsp;CALCULATE(</EM></DIV><DIV><EM>&nbsp; &nbsp; SUMMARIZE( </EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feit_Onderhoudsopdracht_communicatie, </EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feit_Onderhoudsopdracht_communicatie[Opdracht_ID],</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feit_Onderhoudsopdracht_communicatie[Gewijzigde_datum_en_tijd],</EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Datum afspraak", </EM></DIV><DIV><EM>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FORMAT(Feit_Onderhoudsopdracht_communicatie[Gewijzigde_datum_en_tijd], "DD/MM/YYYY")), </EM></DIV><DIV><EM>Feit_Onderhoudsopdracht_communicatie[Status] = "Afspraak huurder",</EM></DIV><DIV><EM>Dim_Onderhoudsopdracht[Status] = "Teruggemeld" || Dim_Onderhoudsopdracht[Status]= "Afgehandeld")</EM></DIV><DIV>&nbsp;</DIV><DIV>I am however getting an error: expression refers to multiple columns. Multiple columns cannot be converted to a scalar value. What's going wrong with my DAX here?</DIV><DIV>&nbsp;</DIV><DIV>Thanks.&nbsp;</DIV></DIV> Tue, 04 Feb 2025 09:16:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393948#M174437 rsch91 2025-02-04T09:16:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393960#M174439 <P>You need to use CALCULATETABLE, not CALCULATE.</P> Tue, 04 Feb 2025 09:21:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393960#M174439 johnt75 2025-02-04T09:21:15Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393984#M174443 <P>bingo. Thank you.&nbsp;</P> Tue, 04 Feb 2025 09:31:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Expression-refers-to-multiple-columns-error/m-p/4393984#M174443 rsch91 2025-02-04T09:31:22Z