Forum Discussion

mmowrey's avatar
mmowrey
Helper I
4 years ago

disting count

I have the follwoing table below.. I would like to get a distinct count of Comp_inv. If i change the field in the filter to a count (distinct)

 

General Comment
Need Help
Show and Tell

4 Replies

  • Shishir22's avatar
    Shishir22
    Solution Sage
    4 years ago

    Hello mmowrey ,

     

    Can you please try Creating measure as -

     

    Measure = DistinctCount(Table[Compinv_id])

     

    Please mark it as Answer if it solves your issue. Kudos are also appreciated.

     

    Cheers,

    Shishir

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, mmowrey ;

    You could try it

    dicount = 
CALCULATE(DISTINCTCOUNT('Table'[COMPINV. _ID]),ALLEXCEPT('Table','Table'[SHIPMENT_ DATETIME]))

    Or

    dicount =  DISTINCTCOUNT('Table'[COMPINV. _ID])

    Or 

    dicount = 
COUNTROWS(SUMMARIZE('Table',[COMPINV. _ID]))

    In my data, those is correct.  you could check the difference about you data. or share more infomation.

    The final output is shown below:


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

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi, mmowrey ;

    Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.


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