Count Issue

[jmiridium]

I am importing data from an Excel spreadsheet or a CSV file to use or charting, the values always automatically count. I don't want this behavior. How do I prevent this?

[MarkS]

This might not be an answer to your question, but you can set the default summarization for your fields.

Select the fields (Time) and on the Modeling tab there is a default summarization that you could set to "Don't Summarize"

HTH

[Anonymous]

Sorry, totally not getting your question.

[jmiridium]

I want it to not count time. Each time is a specific time frame

[jmiridium]

Don't count it, don't sum it. don't count distinct. Just plot the data in the same manner as Excel

[Anonymous]

Gotcha.  In general, values are always aggregated in some way, cuz there will be a set of rows that match that point on the Axis.  Since in your case, you know there is just 1 value... you could just use SUM( ) or AVERAGE( ) or MIN( ) or MAX( ) ... and all would return the same value, no?

[jmiridium]

This is a bad behavior. I should be able to just have the numbers import in the same manner as the excel spreadsheet. If not, this makes PowerBI an ineffective tool to use

[Anonymous]

The closest you can do that what you want... (If I am understanding) is

Current Value := IF (HASONEVALUE(MyTable[MyValue]), VALUES(MyTable[MyValue]))

Putting something on an AXIS (or rows of a table) is very much like using GROUP BY in SQL, if you are familiar there.  The values that you don't group by... need to be wrapped in an aggregate of some kind.  The above measure is just making sure you REALLY only have 1 value (in case you are lying, typically on a grand total cell of a table)... and says "find, give me the 1 value".

In my 4 years of using DAX this wouldn't removely make the list of annoying things about it 🙂

[jmiridium]

y do I have to do anything at all? It should just use the data raw without modifying

[Anonymous]

Typically it would default to SUM( ) and you wouldn't notice this behavior.  I am guessing your datatypes are incorrect (like your value is set to a string).   While I wasn't involved w/ designing the product, so don't really "know"... I can say that some visuals support what you are asking (do not summarize -- say, a table visual), but typically they do not, and that is likely because it doesn't impact you in any way, at all.

Why do you care?  Drop down, select pretty much anything except COUNT( ) and move on with your life?

[jmiridium]

The data in both Excel and the Data view in PowerBI shows the data correctly. It's when I try to graph it, it always counts. If I add a Table and place the data in the table, it shows up incorrectly:

[jmiridium]

I want to be able to do the same thing in Excel with PowerBI: