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.
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