Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add New Column to show Measurement Difference

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

 

 

  • 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!

1 Reply

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support

    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!