Row total is not right , tried few formula , Sumx , but sitll not right

[Chanleakna123]

hi all , 

the result turn out in rows are wrong , it supposed to be around 13,200$ though it show me 68K$. seems like it keep multiply between 360*189 , while this is not the right amount to be display as total. 

i tried using few formula as what i did , though turn out differently : 

: Front Display = [Price Display]*SUM('Weekly Display'[Display in front of Shop/WH])

Test : SUMX(VALUES('Master Data Weekly'[Customer Name Group]),[Front Display]) - this formula still turn out wrong 

[camargos88]

@Chanleakna123 ,

You are relating both tables through 445 calendar, however there are 2 values for tier on Display Price..they are related by date only... is it correct ?

[Chanleakna123]

hi @camargos88  , i have found the solution . thanks you so much for your effort. 

cheersssss :)))))

[camargos88]

@Chanleakna123 ,

Can you share the pbix ?

[Chanleakna123]

Hi @camargos88  , 

https://www.dropbox.com/s/9eqoyhn58gnx2vu/Weekly%20Stability.pbix?dl=0

[mahoneypat · Accepted solution]

Please try this measure expression

NewMeasure =
SUMX (
    SUMMARIZE (
        'Target Weekly Stability',
        Segmentation[Seg.],
        'Master Data Weekly'[Weekly Group Code&Name]
    ),
    [Front Display]
)

Regards,

Pat

[Chanleakna123]

@mahoneypat  , wowwww , you're so brilliant . i was stuck with it for almost a week now. 

thanksyou for paving the way , i am so nascent on measure . thanks you so much , 

Cheers :))))))

[Chanleakna123]

@camargos88  , hi , can you help me on this ?? 

plz

[Chanleakna123]

hi @camargos88  , 

i have 3 main table above as Dimension tables

and 4 belows as the Fact tables , 

Field from Display Price Table : 2-Display front of Shop

Field from Weekly Display Table : 1 or 0 ( Based on Input )

Front Display : [Price Display]*SUM('Weekly Display'[Display in front of Shop/WH])

Test .. : as show in the picture. 

I put in the Metric Visualization which has Seg.  as the Dimension pic i have circle . and Customer Code&Name in Master Data Weekly  . the thing is Front Display result i want  turn out totally Wrong . it sum Altogether. and multiply each other instead  instead of Sum ROW of front display  13,200$ , NOT 68K

[camargos88]

@Chanleakna123 ,

It's replicating the measure Front Display for each row.

Try creating the calculation inside the sumx using row context.

Or give us some data example and the desired output, so we can help with this measure