how to calculate value from column and measure

[df123445]

I have a a measure that calculates the number of rows for a specific content:

CountC = CALCULATE(COUNT('Clicked'[CID]),GROUPBY('Clicked','Clicked'[CONTENT]))

CID	CONTENT
111	ABC
222	ABC
333	ABC
111	DEF

On a separate table I have some benchmark values:

CONTENT	BENCHMARK
ABC	4
DEF	3

I would like to put both values in a visual table and use them both to calculate if the benchmark has been reached (and possibly showing a up or down arrow). 

CONTENT	CountC	BENCHMARK	%
ABC	3	4	-25%
DEF	1	3	-66%

The problem is that I don't know how to get a measure and a column to interact.

Is there a way to do that? 

Many thanks in advance 

[df123445]

Thanks, but when I create

%Benchmark= Count/ sum(Benchmark)-1

and add it to the table I don't get just a value for each type of content but the same value repeated for each 

row. doesn't  sum(Benchmark) just add all benchmarks together?

[Uzi2019]

hi @df123445 
Are u looking for total sum of benchmark?

[Uzi2019]

Hi @df123445 
Can you share the screenshot??

[df123445]

sure, the data is a bit more complex than I said:

 - table open has a measure that counts the number of customer_ids for each content_name

- table list is connected to Benchmarks via Linea 

OPEN:

Customer id	Content
123	CONTENT1
456	CONTENT1
789	CONTENT1
123	CONTENT2

List

CONTENT	LINEA
CONTENT1	Linea1
CONTENT2	Linea1
CONTENT3	Linea2

Benchmarks

LINEA	Benchmark
Linea1	5
Linea2	2

I hope it makes sense.

I woud like to show for each linea a table with a list of content and a sum of customers that opened it, next to it I would like to show the benchmark.

Many thanks again

[v-stephen-msft · Accepted solution]

Hi @df123445 ,

I created the following measure. Please check.

Benchmark% = var _sum=SUM('Benchmark'[Benchmark])
return DIVIDE([CountC]-_sum,_sum)

The same relationship setup as you.

Best Regards,

Stephen Tao

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

[Uzi2019]

Hi @df123445 
Please follow the steps:
Create relationship between 2 tables

then create measure under CID table
Count_content= Count('Table'[Content])

Take table and add all the values you want in the table

Create measure for your % field
%Benchmark= Count/ sum(Benchmark)-1

If my post helps you then give kudos and accept it as a solution!
Thanks