Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Same Expression Different Results

Hi All,   Looking for help with a DAX expression/Calculated table. Context; I am looking to build a data model which tracks tonnage with a split on festival related delivery and non festival relat...
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks for the responses.

    I'm not sure if it's my lack of understanding or experience but I couldn't implement the solutions in the above suggestions.

     

    What I have done is use the "LOOKUPVALUE" function and created a calculated coumn in my data.

    So rather than using a relationship between tables I've essentially used a VLOOKUP as you do in Excel to classify the row.  

     

    I'm not sure it's the best/most efficient/proper way to do this but at least it's worked.

_onto_'s avatar
_onto_
Icon for Helper I rankHelper I
3 years ago

Hi Chris,

 

Screenshot 1 shows Depot Name Revised, screenshot 2 shows Region. Are these two fields the same? Do they come from the same table?

 

QTY x Weight - is this a calculated column? The definition seems a bit convoluted. Since both fields come from the QTY table, why not do QTY[QTY] * QTY[Unit Weight (Added Column)] /1000 ? Or in a measure, [QTY x Weight] = SUMX(QTY, QTY[QTY] * QTY[Unit Weight (Added Column)] /1000)?

 

If you go the measure route the other measures would be:

 

Festivals = Calculate( [QTY x Weight], 'Sales Accounts CSV'[SIC] = "850" )

Festivals (not) = Calculate( [QTY x Weight], 'Sales Accounts CSV'[SIC] <> "850" ) 


Can you include a screenshot from the Manage Relationships window? Topology of your model is not clear.