Forum Discussion

Kagechiyo's avatar
Kagechiyo
New Member
5 years ago
Solved

Distinctcount by excluding column

Hi everybody, this is my first post.   please help me, i would like to distinct count vendorNo, with leadtime filter here is my table year, vendorNo, Account, Leadtime 2020 0007000995 757...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Kagechiyo 

    Please correct me if I am wrong.

    I think the result should be 3.

     

    I am not sure about how you wrote your AVGLT measure, but please kindly check the below measure if it is suitable for you.

     

    DAXcountofVendor =
    VAR removeGL =
    FILTER (
    SUMMARIZE (
    'average lead time',
    'average lead time'[vendor_No],
    "avglt", AVERAGEX ( 'average lead time', 'average lead time'[Leadtime] )
    ),
    [avglt] > 0
    && [avglt] <= 2
    )
    RETURN
    COUNTROWS ( removeGL )

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

Kagechiyo's avatar
Kagechiyo
New Member
5 years ago

 

2020;0007000995;7570004000;1
2020;0003003612;7520002000;1
2020;0003003638;7570003000;1
2020;0007000316;7520002001;1.5
2020;0003002480;7410009000;2
2020;0003000871;7520004001;2
2020;0003002554;7570001000;2.33333333333333
2020;0003000871;7570003000;2.35593220338983
2020;0003002554;7520001000;2.5