Forum Discussion
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,
KellyDid I answer your question? Mark my post as a solution!
1 Reply
- v-kelly-msft
Community 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,
KellyDid I answer your question? Mark my post as a solution!