Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi team,
Hope everyone is doing good! I need some help to resolve the below issue:
Example:
ID | Name | Loc | Des | Age | Value 1 | Value 2 | Value 3 |
1 | ABC | X | Y | 30 | 32 | 245 | 400 |
1 | ABC | X | Y | 30 | 34 | 342 | 876 |
ID | Name | Loc | Des | Age | Value1 | Value 2 | Value 3 |
1 | ABC | X | Y | 30 | 32 | 245 | 400 |
ID | Name | Loc | Des | Age | Value1 | Value 2 | Value 3 |
1 | ABC | X | Y | 30 | 66 | 587 | 1276 |
Can anyone help me with this how I can avoid this aggregation in Power BI and get two separate entries of the row without their values getting summed up? Or anything I can do in AAS to resolve this?
“Don’t summarize” option doesn’t come for VALUES field in Matrix visual so it is coming as ‘SUM’.
Solved! Go to Solution.
Hi @PujaPal ,
As @AllisonKennedy mentioned, Matrix is for aggregating values. We cannot show not summarize data in it directly.
However, you can create a calculated column in your AAS model based on some conditions like rank on value1... and show them in the matrix visual to avoid aggregating indirectly.
index = RANKX('Sheet1','Sheet1'[Value1],,DESC,Dense)
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @PujaPal ,
As @AllisonKennedy mentioned, Matrix is for aggregating values. We cannot show not summarize data in it directly.
However, you can create a calculated column in your AAS model based on some conditions like rank on value1... and show them in the matrix visual to avoid aggregating indirectly.
index = RANKX('Sheet1','Sheet1'[Value1],,DESC,Dense)
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Matrix is for aggregating values. What is the field you're putting in Columns doing? Is it possible to use a table visual instead of matrix?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Actually I need to show headers also on top of the columns, so I am using matrix 😞
So under a single header, 5-6 columns has to be shown, so I had to opt for matrix.
Regards,
Puja
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |