Hello everyone,
I'm having a problem using measure.
My main table has a multitude of columns.
I want to compare the number of line > 0 of theses 6 columns of this table. If I put all 6 values in a single chart, I can't space the bars as far apart as I want. So I make 6 separate graphs.
I place the graphics next to each other, with the spacing that I want.
I want to have the same scale on the Y axis on all 6 graphs.
I made a measure to calculate the maximum value rows > 0 of all 6 columns, it works.
I set the maximum value of the Y axis of the 6 graphs according to the value of this measure.
The problem is that the value of this measure does not take into account the filters of the page.
What is strange is that I added this measure in a "card" on the page, and in this configuration, the measure varies well according to the filters, but the Y axis remains fixed as if it does not there was no active filter the value was null. If I put a value of 0 or 1 to the max Y axis, it behaves the same. It looks like the parameter of max Y axis does not catch the value of the measure.
Here is the code used for the measure:
MaxHeureA = VALUE(
MAXX({CALCULATE(COUNT(Prod_GFR[kWf GF1]),Prod_GFR[kWf GF1]>0),
CALCULATE(COUNT(Prod_GFR[kWf GF2]),Prod_GFR[kWf GF2]>0),
CALCULATE(COUNT(Prod_GFR[kWf GF3]),Prod_GFR[kWf GF3]>0),
CALCULATE(COUNT(Prod_GFR[kWf GF4]),Prod_GFR[kWf GF4]>0),
CALCULATE(COUNT(Prod_GFR[kWf GF5]),Prod_GFR[kWf GF5]>0),
CALCULATE(COUNT(Prod_GFR[kWf GF6]),Prod_GFR[kWf GF6]>0)},
[Value]))
Thanks for your help.
