Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mrmarten
New Member

The real actual value not the count of values

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.the problem

 

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

1 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.

View solution in original post

4 REPLIES 4

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

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.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.