How to filter certain column in table visualisation and shows no items data as blank

[kilala]

Hi All, in my table, i want to display 3 column, Brand, Warehouse, and PIC.

Let say,in Brand I have 10 rows, but only 5 rows is tagged to Warehouse = A. Out of 5 rows, only 2 is being assigned to the PIC.

Hence, in the table i want to show 5 rows, the one that has PIC assigned will show PIC Name. if not, it will be blank. 

Expectation:

Brand	Warehouse	PIC
A	1	kila
B	1	akil
C	1
D	1
E	1

Currently, it only shows those that has being assigned.

Reality:

Brand	Warehouse	PIC
A	1	kila
B	1	akil

[Anonymous · Accepted solution]

Hi  @kilala ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _count=
COUNTX(
    FILTER(ALL('Table'),
    'Table'[Warehouse]=MAX('Table'[Warehouse])&&[PIC]<>BLANK()),[PIC])
return
IF(
    _count<>BLANK(),1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[kilala]

please not that pic for the same warehouse and brand can be more than 1. let say for brand a, warehouse 1, the pic can be kila and ali. so it show in 2 rows.