Forum Discussion

Fuzbe's avatar
Fuzbe
New Member
8 years ago

CALCULATE based on evaluating OR condition between two dimension tables

Hello,

 

I have the need to compute "Custom Revenue" by evaluating an OR condition between two dimension tables.  The following DAX expression failes:

 

Custom Revenue:=
CALCULATE (
[Revenue]
,Table1[Column1] = "Hello" || Table2[Column1]= "World"
)

 

I understand why the above expression fails, but can't seem to figure out how to write a formula that works.  Any ideas welcome!

1 Reply

  • Aron_Moore's avatar
    Aron_Moore
    Solution Specialist
    8 years ago

    I had something similar. Had to figure out if an account was past due then either use an abritrary date or the date on the record.

     

    What I did was put the OR logic in a column, then used that column as the filter in my Calculate.