I need a list of records instead of the count of records.

[harinik1989]

Hi all,

I would like some help in this topic please.  I have created a measure called number of ids excluded, which will calculate the count of the ids excluded from the data based on certain conditions. please find the formula for the measure below:

No of ids excluded = CALCULATE(COUNT('table B'[column_id]),FILTER('table A',OR('table A'[column A]=1||'table A'[column B]=0,'table A'[column C]=1||'table A'[column D]=BLANK())),FILTER('table B','table B'[St_flag]=0))

These are the conditions as per the requirement. If either column A or col B or col c from table A satisfies and st_flag from table B is 0 then include the id in the count.
Now I want to see what are the ids that have been excluded. How can I achieve this. I tried calculatetable but it takes only one condition from only 1 table.
Please suggest some ideas how can i achieve this. Instead of the count, I want to see the list of ids excluded.
Also st_flag is a calculated column in the table B while the rest of the columns are from the DB.

[harinik1989]

Table A
id	column A	column B	column C	column D
0001A	0	1	0	1
0000A	1	0	0
1111A	1	0	0	2
1110A	0	0	0	4
Table B
id	Column A	Column B	St_flag
0001A	0	0	1
0000A	1	1	0
1111A	1	0	0
1110A	1	1	1
Expected Result
id	St_flag
0000A	0
1111A	0
1110A	1

Here is the sample data and expected result as I cannot share the screenshot of actual data. Hope this helps. Basically i need the ids themselves ( or the rows from the table B) which have been excluded instead of just the number of ids (or number of rows from table B). Hope this helps. Any suggestions welcome. 

[v-easonf-msft · Accepted solution]

HI, @harinik1989 

You need add another filter measure and apply this measure to the  visual filter pane of TableB.

filter =
IF (
    OR (
        MAX ( 'Table A'[columnA] ) = 1
            || MAX ( 'Table A'[columnB] ) = 0,
        MAX ( 'Table A'[columnC] ) = 1
            || MAX ( 'Table A'[columnD] ) = BLANK ()
    )
        && MAX ( 'Table B'[St_flag] ) = 0,
    0,
    1
)

Best Regards,
Community Support Team _ Eason

[mangaus1111]

Hi @harinik1989 , please send screenshots of samples table A and B and your expected result.