Forum Discussion

Tommyvhod's avatar
Tommyvhod
Helper II
3 years ago
Solved

Firstnonblank from different table

Hello all   I have 2 tables, in one the production steps of a part and in second the rejected parts IDs.   I would like to add the reject reason code to the rejected table from the production tab...
  • Tommyvhod's avatar
    Tommyvhod
    3 years ago

    SO i was able to solve the issue. I assumed that the FIRSTNOBLANK finds the first no blank values between the filtered data, which seems to be incorrect.

     

    I added another filter with && filtering the process step, there additional results appeared.

    I added a third filter for a third row, reject qty = 1. with these I have correct results.

     

    The final formula looks like:

    reject code = CALCULATE(FIRSTNONBLANK(Data[Rjct code], TRUE()),
    FILTER(Data, Data[ID] = Scrap[ID] && Data[Operacia] = Scrap[OP] && Data[Rejct Qty] = 1))

     

    Maybe there is a more elegant way to do this... long way to learn DAX

     

    Thx

     

     

     

Tommyvhod's avatar
Tommyvhod
Helper II
3 years ago

SO i was able to solve the issue. I assumed that the FIRSTNOBLANK finds the first no blank values between the filtered data, which seems to be incorrect.

 

I added another filter with && filtering the process step, there additional results appeared.

I added a third filter for a third row, reject qty = 1. with these I have correct results.

 

The final formula looks like:

reject code = CALCULATE(FIRSTNONBLANK(Data[Rjct code], TRUE()),
FILTER(Data, Data[ID] = Scrap[ID] && Data[Operacia] = Scrap[OP] && Data[Rejct Qty] = 1))

 

Maybe there is a more elegant way to do this... long way to learn DAX

 

Thx