Exclude row in a table on the basis of Condition

[RuchiChoudhary]

if ContentLogging is present for a resource name then Exclude the row having the value ie. FlagNotSet for the same resource id. If ContentLogging is present for the resourceName and FlagNotSet is not present then ignore. If FlagNotSet is present only for the resourcename then that row should show .

have to filter this row directly in report view - in table

Could you please urgently help in fixing this

s3_account_id	resource name	Custom
1	test	ContentLogging
1	test	FlagNotSet
2	test1	ContentLogging

[RuchiChoudhary]

Have to filter out this row directly in report view.

[olgad]

I updated the answer, take a look at the second part

[olgad]

Hi, if you want to filter those rows out in the visual, then create a Filter column

Filter =

var duplicates=Calculate(COUNTROWS('Tabelle'), ALLEXCEPT('Tabelle', 'Tabelle'[s3_account_id]))

RETURN

If(duplicates=2 && 'Tabelle'[Custom]="FlagNotSet", 0, 1)
and set a page filter or a viz filter to 1 

if you want to remove them out of your dataset then

1. Group Rows

Expand

And filter for 1.

let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUSpJLS4BUs75eSWpeSU++enpmXnpSrE6KLJuOYnpfvklwaklYBkjqIwhFo2xAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [s3_account_id = _t, #"resource name" = _t, Custom = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"s3_account_id", Int64.Type}, {"resource name", type text}, {"Custom", type text}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"s3_account_id"}, {{"Count", each Table.RowCount(_), Int64.Type}, {"All", each _, type table [s3_account_id=nullable number, resource name=nullable text, Custom=nullable text]}}),
#"Expanded All" = Table.ExpandTableColumn(#"Grouped Rows", "All", {"resource name", "Custom"}, {"resource name", "Custom"}),
#"Added Custom" = Table.AddColumn(#"Expanded All", "Filter", each if [Custom]="FlagNotSet" and [Count]=2 then 0 else 1),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Filter] = 1))
in
#"Filtered Rows"