Forum Discussion

OliJov's avatar
OliJov
Frequent Visitor
3 years ago

Measure with duplicates

I have one table A1   B1 A1   B2 and a child table B1    178XX B2    178XX and a fact table 178XX   5 As a result I get in pivot table (this is SSAS, but ok): A1   5 B1   5 B2   5  but th...
OliJov's avatar
OliJov
Frequent Visitor
3 years ago

 

Kazu's avatar
Kazu
Icon for Helper II rankHelper II
3 years ago

I am struggling to unserstand what these three tables are meant to be. If your measure is SUMX(Table3, Table3[amount]), 5 is the correct total (I know it is not what you want, though)

 

Probably your three tables are not designed in a right way. However, since your table names and column names are all dummy, I could not suggest any changes.