Substraction formula of 2 measures not working

[Silvie]

Hi, 

I created 2 measures:

• Cust. Rep. CG = calculate(max('A027 Customer Reputation'[Rep Track Pulse Score]),filter('A027 Customer Reputation','A027 Customer Reputation'[Year] In {"2023"}))

• A027 TOP 1 2023 = calculate(max('A027 Customer Reputation'[Rep Track Pulse Score]),'A027 Customer Reputation'[Company]<>"Colruyt Group",'A027 Customer Reputation'[Year] In {"2023"})

Now I want to substract these 2 measures but the formula doesn't work. 

This is how my formula looks like: Rel. Cust. Rep. 2023 = calculate(sum('A027 Customer Reputation'[Cust. Rep. CG]))-calculate(sum('A027 Customer Reputation'[A027 TOP 1 2023]))

The outcome for 2023 should be 6,07. (77,01 - 70,94)

The table with data looks like this (just a part of the data): 

Kind regards, 

Silvie

[Daniel29195]

@Silvie 

can you share the visual you are building and the data you are getting from using your measure ? 

that would be helpful 

best regards

[Silvie]

HI Daniel,

My apologies for the late reply. For some reason I didn't get a notification. I want to create a KPI card that looks like the one below. The result of the 2 measures I created are mentioned in the table. 

Kind regards, 

Silvie