Forum Discussion
Group Summarized values doesn't return correct total
Hello
this would probably look like this:
Test again ?
SUMX (
SUMMARIZE (
'AUM Config',
'AUM Config'[IDR_BILLING_GROUP], - don't take this from the fact table
'YourDimTableName'[IDR Config SETTINGNA....], // take the field from the Dim table that you have used in the report
'YourDimTableName'[Adjusted MOD_Groupin....], // take the field from the Dim table that was used in the report
"@MKT", SUM ( 'AUM Config'[MKT_VALUE_USD] )
),
SI ( [@MKT] > 0, [@MKT], WHITE () )
)Replace the red text with the model match fields.
ImkeF If you could see the first picture, it has a negative value on the cash group. Once I made the summarized measure, it was gone on the second picture. But the total still shows the one with the negative value (same with the first picture).
Hi msantillan
include both fields from the lowest granularity-level in your visual in the SUMMARIZE.
The totals still include the negative value, because the column-values are still summed up.
Can you please give an example where the column is also included in the Summarized measure ImkeF ? Thank you.
Hello
this would probably look like this:
Test again ?
SUMX (
SUMMARIZE (
'AUM Config',
'AUM Config'[IDR_BILLING_GROUP], - don't take this from the fact table
'YourDimTableName'[IDR Config SETTINGNA....], // take the field from the Dim table that you have used in the report
'YourDimTableName'[Adjusted MOD_Groupin....], // take the field from the Dim table that was used in the report
"@MKT", SUM ( 'AUM Config'[MKT_VALUE_USD] )
),
SI ( [@MKT] > 0, [@MKT], WHITE () )
)Replace the red text with the model match fields.
ImkeF Thanks