Error while using the column chart to compare a single merchant with others with same merchant code

[Iyin]

I'm trying to compare a Merchant that has similar Merchant Codes. I have for instance 'Daffodils Clothing Store' and 'Metro Clothing Store' having the same Merchant code. What I want is that when I select either of these two it will display the selected merchant versus a sum of the two merchant of similar code. This is not the case from my visual as the others just displays the same value of my selected merchant. Can someone help me out?

Below is the code I wrote:

Merchant Vs Others =

VAR CurrentMerchant = MAX('Merchants + Others'[Merchant Name])

VAR SelectedMerchant = ALLSELECTED('Sample payment data'[Merchant Name])

RETURN

SWITCH(

    TRUE(),

    CurrentMerchant IN SelectedMerchant,

    CALCULATE([Sum of Revenue], 'Sample payment data'[Merchant Name] = CurrentMerchant),

    CurrentMerchant = "Others",

    CALCULATE( [Sum of Revenue],

   ALL('Sample payment data'[Merchant Category Code])))

Visual before selection

Visual after selection

[Anonymous]

Hi @Iyin ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng