Forum Discussion
Solved
Measure to calculate each row
I have two tables that are not related. One has the trasaction amount (Table 1) and the other has the factor (Table 2) aplies for an origin currency and a destiny currency. The problem is that i made...
Then you will need to read this article and see if you can create a virtual relationship. Or talk to the person that manages your SSAS and ask them to create a relationship for you at the source. That is really what should be done.
edhans
Community Champion
Community ChampionA couple of things:
- The tables have to be related for any of this to work. You need to relate the LC field in table 1 to the LC field in table 2.
- Use this measure and put it in table 1. (doesn't matter where you put it really, but it wouldn't make much sense in table 2 logically.
Amount Currency Type =
SUMX(
Table1,
Table1[Amount]* RELATED(Table2[FC])
)That will show in your "Table 4" above, which I think is really a visual and not a table.
I cant make the relationship, because this is an example of an Analysis Services conection to power BI and i cant change the AS
- edhans
Then you will need to read this article and see if you can create a virtual relationship. Or talk to the person that manages your SSAS and ask them to create a relationship for you at the source. That is really what should be done.