Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@1up , try
distinctcount(Table[Machine ID])
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.
@1up , try
distinctcount(Table[Machine ID])
Thank you, DISTINCTCOUNT did the trick!
Any ideas why DISTINCT-function is returning an error? Perhaps it needs to be used with another argument?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |