Add New Column to show Measurement Difference

[Anonymous]

I've seen several similar posts but these have not helped me. Thus if you have a moment would you please take a look?

1. What I want to do: Add a new column to a Matrix that shows the difference between two other columns

2. My Schema (in French but I've added English to help)

3. What I want it to look like:

Here's the current Matrix which has the "Question" as the Row, The "Campaign" as the columns, and the Measurement (see below for details)

4. The Measurement (this calculates the Quality):

R_CONFORME_SANS_NA =
DIVIDE
( CALCULATE(sum(F_QUALITE_REPONSE[R_CONFORME]), F_QUALITE_REPONSE[R_CONFORME_NA] <>1 ) ,
CALCULATE(COUNT(F_QUALITE_REPONSE[QUESTION_ID]),
F_QUALITE_REPONSE[R_CONFORME_NA] <>1 ))

5. What I want it to look like

This is an example of the new 3rd column that shows the "Delta" or "Difference" between the two columns

Issues:

I've tried creating a new measurement and referencing that but the SUM function I use expects to see a column in a table (and not a measurement).

Thank you kindly for your help on my first post to the Forum. I tried to make this as clear as possible I hope!

Grixelle

[v-kelly-msft · Accepted solution]

Hi @Anonymous ，

You could create a measure as below:(calculated column can only be available when you convert the other 2 measures into calculated columns)

Measure 2 = 'F_QUALITE_REPONSE'[Measure]-'F_QUALITE_REPONSE'[R_CONFORME_SANS_NA]

And you will see:

For the related .pbix file,pls see attached.

If it doesnt help,could you pls provide detailed data?Thus I could better support you.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!