DISTINCT function throws error: *Calculation error in measure'

[1up]

Hi, I'm trying to find the unique values of a column in a table using DISTINCT function.

However when I try to visualize the result in a Table, the following error is thrown: 

'Calculation error in measure. A table of multiple values was supplied where a single value was expected'.

I have a list of machine names. And would like to count how many there are of each name. Each machine name also has a machine ID which is unique. So I'd like to calculate the amount of Machine IDs for each Machine Name. Thus I tried the DISTINCT function.

Ideas? Perhaps there could be multiple solutions to the same problem.

[v-xuding-msft]

Hi @1up ,

If the formulas that amitchandak and az38 suggested work, please accept them answers as solutions.

If you are still confused about the error, please share the sample data, the formula that you tried and your expected result. Then we will understand clearly.

[amitchandak · Accepted solution]

@1up , try

distinctcount(Table[Machine ID])

[1up]

Thank you, DISTINCTCOUNT did the trick!

Any ideas why DISTINCT-function is returning an error? Perhaps it needs to be used with another argument?

[az38]

hi @1up 

you can just summarize values by adding its into visual as a columns or create a calculated table like

New Table = SUMMARIZE(Table,
Table[Machine Name], "Count Unique ID", COUNT(Table[Machine ID])
)