Forum Discussion
Solved
filter with relationship
Hi I have a table as below : Period Country Sale Type Status 1/1/2020 Vietnam 1 Internal Active 1/1/2020 Lao 3 Internal Active 1/1/2020 Germany 4 External Acti...
ktt777 ,
If your expected output is like above post so follow the below steps and also I attached screen shot for your reference:
Step 1: Create relationship between both the table based on Country.
Step 2: Create DAX Measure like below in SALES table:
Region_Sales = CALCULATE(SUM('SALES'[Sale]),ALLEXCEPT(REGIONS,REGIONS[Region]))
ktt777 ,
If your expected output is like above post so follow the below steps and also I attached screen shot for your reference:
Step 1: Create relationship between both the table based on Country.
Step 2: Create DAX Measure like below in SALES table:
Region_Sales = CALCULATE(SUM('SALES'[Sale]),ALLEXCEPT(REGIONS,REGIONS[Region]))