Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Cool dude,
We have the option to remove the Default Summarization for every measure .
Look the below image .
Cool dude,
We have the option to remove the Default Summarization for every measure .
Look the below image .
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |