Forum Discussion

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)

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

Helper I

4 years ago

returns same large value instead of 16