Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with incorrect totals

Hi All, I have a measure that works fine at site level:     PerformanceSitesTotals = IF(HASONEFILTER('vw_ePos_SalesBySalesItemByDay'[outletId]),[PerformanceSites],SUMX(VALUES('vw_ePos_SalesBySal...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , Simply try like

SUMX(VALUES('vw_ePos_SalesBySalesItemByDay'[outletId]),[PerformanceSites])

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hiya,

    Same result as my current formula. What's happpening is that I have a certain site that opens in the last week of a 15 week period i'm looking at, but then it's treated as an existing site showing massive growth, rather than a new site - which is what that measure totals.

    The 'by week' line graph shows the correct values, but when i drop the weekly filter, it shows incorrectly