Max possible value in measure

[charlotterose]

Hi there, I am looking to get around the issue with the axis cutting off data labels when it has an auto maximum, I would also like to have my axis as static as possible.

Ideally I am wanting to have the conditional maximum Y axis value as [the maximum possible value of my measure] + .0.1

This is easy when just getting the max value, for a date using CALCULATE(MAXX(VALUES(Report_view[Date_Key]),[Rate - Population]) + 0.1)

however my data has a number of dimensions which it can be filtered by:

[Region]

[Location]

[age band]

[sex]

[UR]

[Dep]

Data is then plotted by quarter.

The measue I want the max of is a % so

Report_view[measure_value] / [measure - total population]

What I want, is to be able to calculate, across all the possible combinations, what the maximum % value is, and add 0.1. (like if I was to put them in a table and order high to low, I want that top % value.)

Not sure if this makes sense! may not be possible, but any advice would be greatly appreciated!

[amitchandak]

@charlotterose , Assume you wast a max possible value for measure M1, then it will depend on combination

For region, it will be

Maxx(Values(Table[Region]), [M1])

Same way for multiple combination

Maxx(Summarize(Table, Table[Region], Table[Brand], Table[Age Group]) , [M1])

you can use all selected if needed like

Maxx(Summarize(allselected(Table), Table[Region], Table[Brand], Table[Age Group]) , [M1])

if you are using fact and dim

Maxx(Summarize(allselected(Fact), Region[Region], Item[Brand], Customer[Age Group]) , [M1])