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
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.