cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ANKITBISANI
Advocate I
Advocate I

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

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

Capture.PNG

 

 

 

1 ACCEPTED SOLUTION
Baskar
Resident Rockstar
Resident Rockstar

Cool dude,

 

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

 

Look the below image .

1.JPG

 

 

 

 

View solution in original post

3 REPLIES 3
Baskar
Resident Rockstar
Resident Rockstar

Cool dude,

 

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

 

Look the below image .

1.JPG

 

 

 

 

View solution in original post

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

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.

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors