Forum Discussion

yforti's avatar
yforti
Icon for Helper II rankHelper II
2 years ago
Solved

Help with dax formula

Hi guys! I need to create a measure that counts column "Repetidos" only once per order number (NroPedido2). Currently the measurement is repeated for all lines. As we can see in the image ...
  • VahidDM's avatar
    VahidDM
    2 years ago

    HI yforti 

     

    Try this:

    Repetidos = 
VAR UniqueOrdersPerDay = 
    SUMMARIZE(
        iFrame,
        iFrame[NroPedido2],
        iFrame[DateSession - Copiar],
        "OrderCount", COUNTROWS(iFrame)
    )
VAR RepeatedOrders = 
    SUMMARIZE(
        UniqueOrdersPerDay,
        [NroPedido2],
        "DaysCount", COUNTROWS(UniqueOrdersPerDay)
    )
RETURN
    COUNTROWS(
        FILTER(
            RepeatedOrders,
            [DaysCount] > 1
        )
    )

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!! 

    LinkedIn | Twitter | Blog | YouTube 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi yforti ,

Have you solved your problem? If solved please mark the reply in this post which you think is helpful as a solution to help more others facing the same problem to find a solution quickly, thank you very much!

Best Regards,

Xianda Tang

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