Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone,
I'm new to Power BI
I have a problem where i want to get the actual value of a series of values.
Instead of getting the count that there is one value how can i get the value itself ?
I have tried to do a measure and do: PPM = VALUES(sensorcollection[Document.ppm])
But when i try to pass that PPM Measure to Values i get the following error message:
a table of multiple values was supplied where a single value was expected
What am i doing wrong ?
/Marten
Solved! Go to Solution.
Your fields that you are using are strings, not numeric, thus you only have the count or distinct count option. You need to convert these to numeric (go to the Modeling tab and change the Data Type) and then you can perform aggregations like sum, average, etc. If there is only one value per X axis increment, then these aggregations will return the actual value.
Your fields that you are using are strings, not numeric, thus you only have the count or distinct count option. You need to convert these to numeric (go to the Modeling tab and change the Data Type) and then you can perform aggregations like sum, average, etc. If there is only one value per X axis increment, then these aggregations will return the actual value.
This solution is no longer applicable. When I go to the Modeling Tab, I do not see any way to change the Data Type. Has the way to change data types been updated in the last 7 years?
Thanks Dkay,
That did it! 🙂
I guess i have to take a Power BI 101 Crash Course asap.
/Marten
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
141 | |
79 | |
63 | |
52 | |
46 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |