OR statement with two different columns

Question

Hi there,&nbsp;I have the following scenario:&nbsp;For the measure Historical Overdue I need a measure that counts all values for which the Due Date was exceeded at that moment and which were not yet set (fully paid and written off), the latter can be seen from the closed date. So the date&gt; Due Date &lt;Closed Date, if the Closed date is 1-1-1900 then the post is still open and therefore only date&gt; Due date&nbsp;My measure looks like this:&nbsp;Historical Overdue Receivable = VAR CurrentDate =&nbsp; &nbsp; &nbsp; &nbsp; MAX ( 'Dimension Date'[DateValue] )VAR Overdue =&nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SUM ( 'Fact Receivable'[Receivable Amount EUR] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL ( 'Dimension Date'[DateValue] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Dimension Date'[DateValue] &lt;= CurrentDate,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Fact Receivable'[Receivable Due Date] &gt; CurrentDate&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; || YEAR ( 'Fact Receivable'[Receivable Closed Date] ) = 1900&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,USERELATIONSHIP('Dimension Date'[DateValue], 'Fact Receivable'[Receivable Due Date])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)RETURN&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Overdue&nbsp;As you can see I'm using Due Date and Closed Date and I get the following error, does someone know an alternative?&nbsp;Error: The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression.Hope to hear from you! Thanks in advance.

mahoneypat · Accepted Answer

Please try this instead
&nbsp;
Historical&nbsp;Overdue&nbsp;Receivable&nbsp;=VAR&nbsp;CurrentDate&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;MAX&nbsp;(&nbsp;'Dimension&nbsp;Date'[DateValue]&nbsp;)VAR&nbsp;Overdue&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Amount&nbsp;EUR]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;'Dimension&nbsp;Date'[DateValue]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Dimension&nbsp;Date'[DateValue]&nbsp;&lt;=&nbsp;CurrentDate,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Due&nbsp;Date],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Closed&nbsp;Date]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Due&nbsp;Date]&nbsp;&gt;&nbsp;CurrentDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;||&nbsp;YEAR&nbsp;(&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Closed&nbsp;Date]&nbsp;)&nbsp;=&nbsp;1900&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;USERELATIONSHIP&nbsp;(&nbsp;'Dimension&nbsp;Date'[DateValue],&nbsp;'Fact&nbsp;Receivable'[Receivable&nbsp;Due&nbsp;Date]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;Overdue
&nbsp;
Pat
&nbsp;

Forum Discussion

OR statement with two different columns

1 Reply

Related content

New Column with IF STATEMENT

IF statement in custom column

Switch statement for columns from different tables

If Statement Calculated Column Returning Incorrectly

OR Statement ?