Confusion on some columns(Non-Aggregate ) with Summation sign in Modelling pane

[ANKITBISANI]

Hello Everyone ,

We have followed the below steps : 

1. Imported the data file 

2. We view it on the modeling pane in the desktop 

Observation : Suppose we imported the basic fact file "fact_Product_sales" with columns as Product Key , Territory key , Sales.

We have our Product key as data type integer . So Power BI desktop considers Product key as summation and there is a summation sign through we dont want to use it as aggregatable column OR Measures.

Questions : 

How to remove those summation sign as we wont be using as measures . If we want to convert it into Columns for filters and other reporting use .

OR 

Will that sign affect creating relationship using product key Or in Hierarchies

Regards ,

Ankit

[Baskar · Accepted solution]

Cool dude,

We have the option to remove the Default Summarization for every measure .

Look the below image .

[ANKITBISANI]

Thank you Dude ,

So , are you saying that through product key is ideally a attribute(non-Aggregatable) but due to integers in that column , Power BI considers it as a measure or Aggregatable ?

And by removing the same , we will be using it as a non - meaure thing .

Regards ,

Ankit

[Baskar]

yes for First point,Because of integer it will go with aggregation. so it was consider as measure.

ya we can use as non measure as well eeven in Axis also.