Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Measure from non related Table Always null

Hi Everyone, I hope somebdy will be able to help me, i've been reading hundreds of forum topics all night long, and im desperate right now 😕    Here is my schema of Data,    Here is the co...
Data Protection
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you PaulDBrown for taking the time to replying me. 

 

Where is the LCBO Promo Period field coming from?

LCBO Promo Period  is coming from my table Calendar (which is linked to both fact tables (financial & fact promotion)) 

 

Also do the date keys in your Finance and Fact promotion have the same granularity (it seems the Finance table has a year granularity while the Fact Promotion table has a day granularity).

No, both fact tables has the same granularity (date key) and have same dimensions linked to them (Calendar / Product LCBO / product Bridge )

 

Also make sure that any fields in the visual come from the dimension tables (not the fact tables)

I dont get it ? can you please explain 

 

 

 

 

 

 

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Perhaps try:

_measure = SUMX(

SUMMARIZE(calendar, Calendar [LCBO Promo Period], "_COGS", [sum9l] * [total Shipment Actual Cost Of Goods Sold]),

[_COGS])