Forum Discussion

luizzed's avatar
luizzed
Frequent Visitor
5 years ago
Solved

Conditional with DAX using columns from different tables

Hi! I have two tables: dimension fact with this relationship I'm trying to make a measure that when the value of the dimension[Value] column is empty, use the value of the fact...
Need Help
  • smpa01's avatar
    smpa01
    5 years ago
    Measure = 
IF (
    MAX ( dim[Value] ) = BLANK (),
    CALCULATE (
        MAXX ( FILTER ( 'fact', 'fact'[Index] = MAX ( dim[Index] ) ), 'fact'[Value] )
    ),
    MAX ( dim[Value] )
)

    luizzed 

     

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Hello that such community, I have a similar request, I want to place a UNIQUE value in a "CARD" try with the code that comes in the previous example but did not come out excato what I need.

My problem is as follows:

Thank you in advance for your valuable contributions