How I can compare one agent in data vs the rest of the data

[Didacster]

I have a table of different agents in one column, and two columns with the billing and origin of every payment. 

Every line is a date with the name of agent, and both values. 

I'm trying to created one chart with information of a agents selected with a filter, thats easy.

The problem is when I try to created another chart with the information about the rest of agents, for compare the distribuetion of billing vs portfolio. 

In my attempt, I have created a measure and aply to the filter of chart with the DAX sentence: 

"measure = CALCULATE(

    IF( ISFILTERED(TABLE[COLUM_AGENT]),0,1), 

    allselected(TABLE))"

With this sentence I try ti evaluate every line of column, but only evaluate if the colum is filtered...,

Thank you!

[v-yadongf-msft]

Hi @Didacster ,

In order to better understanding your demands and give the right solution, could you please share with me some screenshots of your data after hiding sensitive information and tell me what's your expected output?

Thanks for your efforts & time in advance.

Best regards,

Yadong Fang