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.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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

thank you, Jihwan_Kim 
after some modification i manage to get what i want..

 

but i understand that there is another way to count the distinct.

is by grouping.

 

thanx=]