Filtrar y traer otros

Hi YOSIEMPREYO12 ,

To meet your requirement of displaying data for the selected supplier in one visual and all other suppliers in a second visual, follow these steps:

Create a disconnected slicer table named Supplier_Disconnected using the following DAX formula:

Supplier_Disconnected = VALUES('table'[Supplier Name])

Use Supplier_Disconnected[Supplier Name] in your slicer visual.

Create a DAX measure named EXCLUDE as follows:

EXCLUDE = SWITCH(TRUE(),
ISFILTERED(Supplier_Disconnected[Supplier Name]) &&
VALUES('table'[Supplier Name]) IN VALUES(Supplier_Disconnected[Supplier Name]), 0,1)

Apply the EXCLUDE measure as a visual-level filter:
For the first table visual (to show all suppliers except the selected one), set the filter to EXCLUDE = 1.
For the second table visual (to show only the selected supplier), set the filter to EXCLUDE = 0.

Please look into the PBIX file for your reference.

Best Regards,

Chaithra.