Forum Discussion
calculate a measure, with multiple conditions, that include static numbers for diff years?
- 4 years ago
Hi nrj1806 ,
Not sure about your data and model, but since you are using the year as the legend, you need to use the same field in the measure to compare.
total Save Money = SWITCH ( MAX ( 'Date'[Calendar Year] ), 2022, ( 49 / 60 ) * 350 * CALCULATE ( SUM ( 'QUESTIONAIRES_CLEANED'[QUESTIONNAIRE_COUNT] ), 'QUESTIONNAIRES'[QUESTIONNAIRES_NAME] = "Corporate notary generator EN" ), 2021, ( 30 / 60 ) * 350 * CALCULATE ( SUM ( 'QUESTIONAIRES_CLEANED'[QUESTIONNAIRE_COUNT] ), 'SP-QUESTIONNAIRES'[QUESTIONNAIRES_NAME] = "Corporate notary generator EN" ), 0 )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nrj1806 ,
Not sure about your data and model, but since you are using the year as the legend, you need to use the same field in the measure to compare.
total Save Money =
SWITCH (
MAX ( 'Date'[Calendar Year] ),
2022,
( 49 / 60 ) * 350
* CALCULATE (
SUM ( 'QUESTIONAIRES_CLEANED'[QUESTIONNAIRE_COUNT] ),
'QUESTIONNAIRES'[QUESTIONNAIRES_NAME] = "Corporate notary generator EN"
),
2021,
( 30 / 60 ) * 350
* CALCULATE (
SUM ( 'QUESTIONAIRES_CLEANED'[QUESTIONNAIRE_COUNT] ),
'SP-QUESTIONNAIRES'[QUESTIONNAIRES_NAME] = "Corporate notary generator EN"
),
0
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- nrj18064 years agoFrequent Visitor
This worked! i realised the format of my formula wasnt correct. Thank you!