Newbie doubt - Modify a Measure to work on 2 steps uphill table

[arlequin71]

Hello,

Could you help me?, I need to modify the measure: SelloutCY_CLP = SUM('dwSellOutFact'[Sales_USD])

to properly work with dimmensions located in Sfr_ProductDim table 

This is the current schema:

Thanks in advance for your help,

Alex-

[AlB]

Hi @arlequin71

I think you might want to use the concept of expanded tables. Have a look at this and this articles from the Italian gurus.

In any case you'd need to be a bit more precise in explaining what you actually need and showing for instance the relationships in your model. Sharing the pbix would be best. 

Try this, although it's a bit of a shoot in the dark:

SelloutCY_CLP =
CALCULATE ( SUM ( 'dwSellOutFact'[Sales_USD] ), Sfr_ProductDim )

[arlequin71 · Accepted solution]

It works thanks!.... 

I just need to apply now to a YTD measure.