Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX : Create a filtered column based on another column

Hello,    I'm struggling with a DAX column calculation, I want to create a column based on a specific row, there are information about columns concerned :    - Event_Biztranslist : ID of parcel ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    Try this:

    Column =
CALCULATE (
    FIRSTNONBLANK ( 'Table (2)'[Relation_Type], MIN ( 'Table (2)'[Event_Time] ) ),
    FILTER (
        ALLEXCEPT ( 'Table (2)', 'Table (2)'[Event_Biztranslist] ),
        'Table (2)'[Event_Type] = "OE"
    )
)

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello amitchandak 

     

    Thanks for your answer, 

    The rank had already done in the concerned columns, the idea is to return for each row of the parcel ID, the value of [Readpoint_type] associated to the "ObjectEvent" value 

     

    Driss