CODEWITHSUNDEEP
powerbidaxpowerbi-desktopmeasureexcept
jcoke
jcoke

Reputation: 1891

How to Filter a Disconnected Table

I have a main table (Table 1) and I have created another table which is called rangeBefore (Table 2):

rangedBefore (Table 2) = 
FILTER (
SUMMARIZE ( 'Campaign Overview', 'Campaign Overview'[campaign],'Campaign Overview'[range_name], 'Campaign Overview'[ranged_flag_in_words] ),
'Campaign Overview'[ranged_flag_in_words] = "RANGED")

enter image description here

What I am trying to do is return the main table but do not show any names which appear in Table 2, but I'm not quite sure how to go about this using DAX.

Upvotes: 1

Views: 213

Answers (1)

davidebacci
davidebacci

Reputation: 30304

Create a new measure as follows:

Measure Test = 
VAR x = VALUES(rangedBefore[range_name])
VAR y = SELECTEDVALUE('Campaign Overview'[range_name])
RETURN
IF(y in x, 1)

Add it to the visual filters on your first table as follows:

enter image description here

Upvotes: 1

Related Questions