Forum Discussion
scuderiluigi
2 years agoRegular Visitor
Measuring where two different dimensions in different tables have the same value
Hi everyone, I'm trying to create a measure called "Local transactions" where the country of the seller is the same of the country of the buyer. The country of seller is in the seller data table an...
scuderiluigi
2 years agoRegular Visitor
Hi, unfortunately I had no answer for this question
I managed to solve by doading in the fact table, in the ETL phase, the seller region and the buyer region with the join, and by creating a colum called local set to yes if the seller region is equal to the buyer region and to no if not
I just wander if there is a different way with some dax command