Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DAX error

Hi All,

 

I have appended the query multiple times and I did not seem to have any issue, until now.

Thats the formula I used, I am not sure what the problem is.

There are no duplicate values. I double checked and it is still throwing error.

Any help is appreciated!

Thank you!

 

Get Help

4 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    The error implies that 'Part File' contains multiple rows where 'Part File'[PartPlantbyYearWeekNum] is the same but has different values of [OrderMinimumQty].

     

    Try defining a calculated table like this to try finding where this occurs:

    Summary =
FILTER (
    SUMMARIZE (
        'Part File',
        'Part File'[PartPlantbyYearWeekNum],
        "DistinctQty", DISTINCTCOUNT ( 'Part File'[OrderMinimumQty] )
    ),
    [DistinctQty] > 1
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you! AlexisOlson 

      This is the result I got:

      I dont see the partplantbyYearWeekNum being repeated.

      I still quite not understand what the problem is.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I understood what the problem is.

        PartplantByYearWeekNumber is repeated twice with different orderminqty.

        Thank you! AlexisOlson 

        Can I please know how to fix that?

        Thanks again!