Problem with the range of measures presented in the chart

[Zbig62]

Hello

I have a problem with mastering the range of measures presented on a line chart.

After setting filters in the table, I get the correct results. One on the chart for the entire range of data (from 1 to 83) one of the measures LCL(IX)50_lines shows values ​​from the range of 1 to 500.....

However, if I limit the range to, for example, 1 - 82, all measures are presented correctly

I am trying to limit the scope of this measure but without any positive effects

LCL(IX)50_lines =

VAR a = COUNTX(ALLSELECTED('public Measurement'); 'public Measurement'[result])

RETURN

CALCULATE(

    [Cl(IX)50_lines] - 2,66 * [CL(MR)50_lines];

    'public Measurement'[number] <= a

)

I kindly ask for help

Best regards

[Anonymous]

Hi  @Zbig62 ,

If it is convenient, could you describe the dax formulas for [CL(IX)50_row] and [CL(MR)50_row]?

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Liu Yang

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

[Zbig62]

Ok

I'll try to isolate the problem. Below is a formula that works correctly for the data range set on the filters, all values ​​are correct.

Cl(IX)50_lines =

VAR a = 50

VAR mn = MINX(ALLSELECTED('public Measurement'); 'public Measurement'[number])

VAR mx = MAXX(ALLSELECTED('public Measurement'); 'public Measurement'[number])

VAR MxM = mx - mn

VAR d = IF(MxM <= a; mn; mx - a)

RETURN

CALCULATE(

    AVERAGEX(

        'public Measurement';

        'public Measurement'[result]

    );

    FILTER(

        ALLSELECTED('public Measurement');

        'public Measurement'[characteristicId] = MAX('public Measurement'[characteristicId]) &&

        'public Measurement'[number] >= d

    )

)

I need to create a second measure that will subtract a value of, for example, 2.66 from the value of the first measure (Cl(IX)50_lines).

LCL50 Test =

VAR a = MAXX(ALLSELECTED('public Measurement'); 'public Measurement'[number])

RETURN

CALCULATE(

    [CL(IX)50] - 2,66;

    FILTER(

        ALLSELECTED('public Measurement');

        'public Measurement'[number] <= a

    )

)

I get the correct result but the data range changes. Where is the error?

please help