Forum Discussion
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...
Hi, thank you for replying.
The seller table and the buyer table have a connection to the fact table, that contains both the seller id and the buyer id.
The purpose is to highlight the percentage of transactions that sellers make with buyers of their own country.
In case you need to understand better I created a sample pbix with random data