I have written a Measusre which helps me get the values from two tables, where I want to compare the first table to second table using the column Index in both the tables.
First sep I extract Index column values from both the tables:
CombinedIndexes =
VAR SelectedIndexesList =
SELECTCOLUMNS(
VAR StartDate = MIN('Relation_Association'[published_on])
VAR EndDate = MAX('Relation_Association'[published_on])
RETURN
FILTER( Relation_Association, Relation_Association[published_on] >= StartDate && Relation_Association[published_on] <= EndDate ),
"Index", Relation_Association[Index] )
VAR SelectedIndexesList_2 =
SELECTCOLUMNS(
VAR StartDate = MIN('Relation_Association_2'[published_on])
VAR EndDate = MAX('Relation_Association_2'[published_on])
RETURN FILTER( Relation_Association_2, Relation_Association_2[published_on] >= StartDate && Relation_Association_2[published_on] <= EndDate ),
"Index", Relation_Association_2[Index] )
VAR Difference = EXCEPT(SelectedIndexesList_2, SelectedIndexesList)
RETURN Difference
But when I use it in the visual, I expect to have the values that are not present in SelectedIndexesList but present in SelectedIndexesList_2. When I put this in a card visual i get "Cant disply the visual" error.
Can someone let me know how can I get the logic to work where I would like to have the values on the indexes not present in SelectedIndexesList but present in SelectedIndexesList_2.
