Propagating an ID

[CarlsBerg999]

Hi,

I'm having difficulties creating a Calculated Column for a scenario: The goal is to create a dax for the result column. 

Each platform has atleast 1 Indicator markek as "X". If there are multiple "X"'s, the ID2 is the same for these items.

I want to propagate the indicated ID2 to all results in the same platform. Therefore, all rows in Platform 123 have Result of 531 and all rows in platform 321 have a result of 510.

My current dax is faulty:   
CALCULATE(MAX(ID2),
PLATFORM = EARLIER(PLATFORM),

INDICATOR = "X")

This does not propagate the correct result to all rows, only the rows that have an indicator. Any ideas?

Platform	ID2	Indicator	Result
123	514		531
123	54		531
123	531	X	531
123			531
321	15		510
321	510	X	510
321	510	X	510
321	5		510

[v-yiruan-msft · Accepted solution]

Hi @CarlsBerg999 ,

You can update the formula of your calculated column [Result] as below:

Result = 
CALCULATE (
    MAX ( 'Table'[ID2] ),
    FILTER (
        'Table',
        'Table'[Platform] = EARLIER ( 'Table'[Platform] )
            && 'Table'[Indicator] = "X"
    )
)

If the above one can't help you get the desired result, please provide more sample data(exclude sensitive data) and the correct result with backend logic and special examples. Thank you.

Best Regards

[Tahreem24]

@CarlsBerg999 Try this DAX Column:

Column = CALCULATE(MAX(Table[ID2]),ALLEXCEPT(Table,Table[Platform]))