Dax filter question for competitive comparison

Hi Perplexed ,

To show the "Home" vendor's revenue only in the markets where the selected vendor from the slicer appears, you'll need a measure that checks two things: whether the row is the selected vendor, or whether it's the "Home" vendor in a market where the selected vendor operates. First, use SELECTEDVALUE to capture the vendor selected in the slicer:

SelectedVendor = SELECTEDVALUE(Data[Vendor])

Next, write your main measure that filters the data based on whether the current row is for the selected vendor or for "Home" in a relevant market:

ShowRevenue =
VAR SelectedVendor = SELECTEDVALUE(Data[Vendor])
VAR CurrentVendor = MAX(Data[Vendor])
VAR CurrentMarket = MAX(Data[Market])
VAR MarketsWithSelectedVendor =
    CALCULATETABLE(
        VALUES(Data[Market]),
        Data[Vendor] = SelectedVendor
    )
RETURN
IF (
    CurrentVendor = SelectedVendor
    || (
        CurrentVendor = "Home"
        && CurrentMarket IN MarketsWithSelectedVendor
    ),
    SUM(Data[Revenue])
)

Add this measure to a matrix visual with Market and Vendor as rows and this ShowRevenue measure as values. Then, add a slicer on the Vendor field. When a vendor like "A" is selected, the matrix will show their revenues in relevant markets and also show the "Home" vendor's revenue in those same markets, ignoring all others.

Best regards,