Forum Discussion

mirf's avatar
mirf
Frequent Visitor
2 years ago

Divide two different tables gives incorrect value

I have cost & production matrix as below I want to have third matrix, which divides cost from each country by its production.  I have used this measure: intensiity = SUM(Cost[Value])/sum(Produ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi mirf 

the continent/country should be in a separate connected dimension table. Same applies to asset type. 

mirf's avatar
mirf
Frequent Visitor
2 years ago

Yes, I already create separate table for continent, country and make relationship but no success

 

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    2 years ago

    mirf 

    Which tabe?  I cannot find it in the data model.