disting count

[mmowrey]

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)

[v-yalanwu-msft]

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.

[v-yalanwu-msft]

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.

[Shishir22]

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

[mmowrey]

returns same large value instead of 16