Display values on the visual from Table A which is not present on Table B

[unnipbi123]

Hello All,

I am requesting an idea to acheive the below scenario. Please let me know if you can help.

I have a table in my report with the  structure like below.

Table A:

I have created a matrix visual out of this table with the below condition

count of resellers under each dist whose user_last month is not 0 but the user_current month is 0(Basically to understand the churn)

Now i have a request that few resellers needs to be exceptioned from the report for particular month as they will be on a special request for specific months. i have created an exception report like below which i can import to power bi

Table B: 

Now my visual should not consider the resellers who are present in this exception table for the specified date. the problem here is i cannot make any changes to my Table A as there are many other reports created out of the Table A. What I am thinking is i can create a relationship between table A and Table B and use the reseller ID of Table B in filters to exclude it. but the reseller id should be excluded only for the specific date mentioned on table B. 

Please anyone help me how to acheive this.

[v-yangliu-msft · Accepted solution]

Hi  @unnipbi123 ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _date=SELECTCOLUMNS('TableB',"Date",'TableB'[Date])
var _ResellerID=SELECTCOLUMNS('TableB',"Reseller",'TableB'[Reseller ID])
return
IF(
    MAX('TableA'[Date]) in _date &&MAX('TableA'[Reseller ID]) in _ResellerID ,0,1)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[amitchandak]

@unnipbi123 , Assume you have measure from table A and table B

A = countrows(A)

B = countrows(B)

Assume retailed and date etc are common and filtering

In B not in A

Countx(Values(reseller[reseller ID]), if(not(isblank([B])) && isblank([A]) , [reseller ID], blank()) )

Use with reseller id