The real actual value not the count of values

[mrmarten]

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

[dkay84_PowerBI · Accepted 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.

[jbuzy5000]

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?

[mrmarten]

Thanks Dkay,

That did it! 🙂

I guess i have to take a Power BI 101 Crash Course asap.

/Marten

[dkay84_PowerBI]

Always make sure to check the data types of your fields. You can easily tell if one is numeric or not because numeric types will have a sigma sign in front of the name in the fields list.