Ignore visual filter in measure with maxx and summarize

[Anonymous]

Hey together,

i have one bar chart which i copy+pasted three times. Then i apply different visual filters to the charts (all from the same column). 

Now i want to sync the max value on the y-axis for all charts depending on the overall max value. 

To do this i have to write a measure which i add to the y-axis settings: 

I wrote this measure:

Max y-axis value =

MAXX(
         SUMMARIZE(Kostenarten, Kostenarten[Bez. Kostenart], "MaxY", SUM(Buchungen[Betrag])), [MaxY])

Without a visual filter the measure does what it should. But my problem is now that i don't find a solution to add some part in this measure which does ignoring the visual filter. The column which filters the visuals is called "Kostenarten[Zuordnung].

Thanks everybody.

Nico

[Anonymous]

Hi @Anonymous ,

What is your desired output? please provide more details with your desired output and pbix file without  priavcy information.

How to Get Your Question Answered Quickly 

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey @Anonymous ,

sure, you're right.

Data model:

These are the three bar charts:

and all of them use the same columns:

And all of them use the same column for visual filter with different values from this column:

The desired output is now a measure which gives me the overall max value from the bar charts. In the case above "1.364.127 €". But the important thing is now that the visual filter (Kostenarten[Zuorndung]) is not affecting the max value. 

The desired output is here that all three bar charts have the same max value in the y-axis to make them comparable.