Forum Discussion
Calculating override fields correctly
Hello,
I am trying to use override fields; basically a manually input number that serves to override whatever is in the system. I need to create a measure which gives me the totals from the system, but incorporates any override fields into that total instead of what is being read from the system.
When trying to use the ISBLANK function, my totals are just giving me any override figure. I can see why below, but I am unsure how to express a sum total for the system totals, with the exception of the presence of an override field.
In the attached screenshot, I would expect the total to be 6,554,503.
Anonymous , Try a measure given below, I am assuming [Override totals] and [System totals] are measures
sumx(values(Segment[Segment Name]),calculate(Final totals = IF(
ISBLANK('Table1'[Override totals]),
'Table2'[System totals],
'Table1'[Override totals]) ) )
2 Replies
Anonymous , Try a measure given below, I am assuming [Override totals] and [System totals] are measures
sumx(values(Segment[Segment Name]),calculate(Final totals = IF(
ISBLANK('Table1'[Override totals]),
'Table2'[System totals],
'Table1'[Override totals]) ) )