TOP N DAX Error

[ACUNILIN]

Hello,

I am trying to do a TOP N to find the most common leadtimes for our cutomers. 

Here is the formula I have written.

But I get the following error message on the visual

I don't see how it's looking at multiple columns. The requested to confrimed leadtime column is a calculated column that takes the date diff of requested delivery date and confirmed delivery date.

I have tried changing the formula to use actual delivered quantity to see if this got rid of the multiple columns message, as this comes straight from the query but the error message was the same.

Can anyone help?

[v-yingjl · Accepted solution]

Hi @ACUNILIN ,

TOPN()  returns the top N rows of the specified table, you can not use it directly in the formula, it uses as a 'filter' in the formula, for example:

Measure = 
CALCULATE(
    SUM('Table'[Value]),
    TOPN(
        5,
        ALL('Table'),
        'Table'[Value],ASC
    )
)

You need to use the TopN() function with other calculation formulas at the same time.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ACUNILIN , Refer to my video, I  have discussed how to use TOPN

https://youtu.be/QIVEFp-QiOk