cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
iskono Frequent Visitor
Frequent Visitor

Don't want "Count of...

hello , i am facing problem , when i add a numiric field it keeps getting the count , and i dont want to show the count so how do i fix ?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
SabineOussi Established Member
Established Member

Re: Don't want "Count of...

Did you check the column's default summarization property?

 

Go to the Data view and make sure default summarization is set to "Do Not Summarize".

 

Hope this helps!

5 REPLIES 5
Super User
Super User

Re: Don't want "Count of...

Has this column been explicitely formatted as number already?

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




iskono Frequent Visitor
Frequent Visitor

Re: Don't want "Count of...

yes , and iv'e changed the type to text but still , it counts

Super User
Super User

Re: Don't want "Count of...

Well - then it behaves as it should:

A measure (as opposed to a field from a column) will always show some sort of aggregation. If it is formatted as numeric it will default to SUM, but if it is formatted as text, it will default to COUNT.

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Highlighted
SabineOussi Established Member
Established Member

Re: Don't want "Count of...

Did you check the column's default summarization property?

 

Go to the Data view and make sure default summarization is set to "Do Not Summarize".

 

Hope this helps!

iskono Frequent Visitor
Frequent Visitor

Re: Don't want "Count of...

example of my data ,

 

domain names i have owned , running ports , fixed ip and last field is count ( agrigated sumurized )

 

problem is it counts uses ports