Forum Discussion
Y axis calculation
Hi,
In the day version of my dashboard, use a custom measure statement to increase the size of the y axis by a factor of 1.4 to allow for the display of a % compliance line above my clustered columns.
= max(MAXX(KEEPFILTERS(VALUES('MQY'[date])), calculate(
MAX(SUM('MQY'[ent]),SUM('MQY'[forecast_iv]))
,KEEPFILTERS('MQY'[forecast_iv])
)),MAXX(KEEPFILTERS(VALUES('MQY'[date])), calculate(
MAX(SUM('MQY'[ent]),SUM('MQY'[forecast_iv]))
,KEEPFILTERS('MQY'[ent])
))) *1.4
Now, I need to add another page to my report to show the results by month, quarter and year.
How do I modify my statement above to sum the months figures so I can add the 1.4 factor?
Thanks in advance....
HI da_heff,
You can try to use the following measure formula if helps:
formula = CALCULATE ( MAX ( CALCULATE ( MAX ( SUM ( 'MQY'[ent] ), SUM ( 'MQY'[forecast_iv] ) ), VALUES ( 'MQY'[forecast_iv] ) ), CALCULATE ( MAX ( SUM ( 'MQY'[ent] ), SUM ( 'MQY'[forecast_iv] ) ), VALUES ( 'MQY'[ent] ) ) ), VALUES ( 'MQY'[date] ) ) * 1.4If the above also doesn't help, can you please share a pbix or some dummy data that keep raw data structure with expected results? They will help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
2 Replies
HI da_heff,
You can try to use the following measure formula if helps:
formula = CALCULATE ( MAX ( CALCULATE ( MAX ( SUM ( 'MQY'[ent] ), SUM ( 'MQY'[forecast_iv] ) ), VALUES ( 'MQY'[forecast_iv] ) ), CALCULATE ( MAX ( SUM ( 'MQY'[ent] ), SUM ( 'MQY'[forecast_iv] ) ), VALUES ( 'MQY'[ent] ) ) ), VALUES ( 'MQY'[date] ) ) * 1.4If the above also doesn't help, can you please share a pbix or some dummy data that keep raw data structure with expected results? They will help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
