Display the data in a new table with Filter condition in Power BI

[sarath5140]

Hi Folks,

Can you help me in getting solution for my below problem.

I have a table with the below data 

ID	Type	ReportId
11	A	123
12	A	124
13	A
14	A
15	B	126
16	B	127
17	B	2812

Now i want my output to have it in new table when Type as "A", i should have values only which are blank of ReportID.

My output should be like this

ID	Type	ReportId
13	A
14	A
15	B	126
16	B	127
17	B	2812

Thanks

[AlB · Accepted solution]

Hi @sarath5140 

Create a new calculated table, where Table1 is the table you show

NewTable = FILTER(Table1, NOT (Table1[Type]="A" &&  NOT ISBLANK(Table1[ReportId])))

[parry2k]

@sarath5140 so you want to show all the blanks for "type" selected in slicer and also the remaining types, correcT? In your output, you are showing blank for type "A" and also rows from type "B"

[sarath5140]

Hi @parry2k 

Yes, Correct. But I want the data to be shown in new table. Like kind of Summarize table.

Thanks