Y axis calculation

[da_heff]

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....

[v-shex-msft · Accepted solution]

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.4

If 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

[amitchandak]

@da_heff , Not very clear. But the max should be

calculate([measure], allselected()) * 1.4