Filter result from each row and column

[gauravnarchal]

Dear All - I need help to create a measure to filter the result of each client and display the result in the table. Please let me know if this is possible.

Client 123, i want FF1, FF2 & FF3 only

Client 125, i want FF4, FF6 & FF6 only

Client 126, i want FF5, FF6, FF8 & FF9 only

DATA

Client Number	Client Name	FF1	FF2	FF3	FF4	FF5	FF6	FF7	FF8	FF9
123	ABC Group	XHJUYIL	98768909	909889		T78787		IUIO345
123	ABC Group	XHJUYIL	98768907	909887			H79798
123	ABC Group	XHJUYIL	98768907	909885
125	NCM Group				OJKIJIKL		37838	WAGSGS
126	ACM GROUP					564456	121288		UT6769	QWA7979

Result to be displayed as below in the Table

Client Number	Client Name	A	B	C	D
123	ABC Group	XHJUYIL	98768909	909889
123	ABC Group	XHJUYIL	98768907	909887
123	ABC Group	XHJUYIL	98768907	909885
125	NCM Group	OJKIJIKL	37838	WAGSGS
126	ACM GROUP	564456	121288	UT6769	QWA7979

[V-lianl-msft]

Hi @gauravnarchal ,

See if this meets your needs

Unpivot the FF1-9 columns and create a measure to apply it to visual level filter.

Measure = SWITCH(TRUE(),
MAX('Table'[Client Number])=123&&MAX('Table'[Attribute])in {"FF1","FF2","FF3"},1,
MAX('Table'[Client Number])=125&&MAX('Table'[Attribute])in {"FF4","FF6","FF7"},1,
MAX('Table'[Client Number])=126&&MAX('Table'[Attribute])in {"FF6","FF8","FF9"},1
)

Sample .pbix 

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

[HotChilli]

Typo in "Client 125, i want FF4, FF6 & FF6 only"?

---

If you are more comfortable with the interface rather than M:

Duplicate the table 2 times.

1st table : Filter for client = 123. Remove columns 4-9. Rename FF columns as A, B, C

2nd table : Filter for client = 125. Remove columns 1,2,3,5,8,9?.  Rename FF columns as A, B, C

3rd table : you get the idea.

"Append as new" the 3 tables together