Forum Discussion
Helper ICant get correct total on complex model
You're welcome,
Yes I tried it in the file you sent and it worked.
No worries.
Helper II cannot drop the ALLSELETED(), otherwise it will not aggregate regardless of the ALLSELECTED arguments.
I mean; I added certain columns to ALLSELECTED like CLIENTID, because I want an aggregate value regardless of CLIENTID
Solution SageNot the best solution, but as an easy and fast solution to fix it, please try this as well. It should work for your total:
Measure =
VAR _TABLEE =
ADDCOLUMNS (
SUMMARIZE (
GENERAL_ACCOUNT,
GENERAL_ACCOUNT[BU],
GENERAL_ACCOUNT[Link],
GENERAL_ACCOUNT[ACCOUNTCODE]
),
"@measure3", [measure3]
)
RETURN
SUMX ( _TABLEE, [@measure3] )
- Mostafa-Hussien
Thanks MohammadLoran25
This works fine for returning positive and negative values and correct total
But how can i retrieve only positive values while retaining a correct total ?
- MohammadLoran25
Your [measure3] only returns postivie value so the measure I sent recently should work for positive values.
- Mostafa-Hussien
Thanks MohammadLoran25
Oh sorry, I corrected my measure according to what you said.
Now it returns the correct positive line value but still the total is zero