Constant Threshold calculation

[vincentllx]

Hi, 

I'd like to calculate a threshold as follow (using a measure) : I have 13 periods in a a year, but I only use the first 5 to calculate the mean. Once I put this measure in the visualisation, I d'like to have a constant, but rather I have a fluctuating line.

Why ? And how can I have a constant instead ?

Moy2019 = CALCULATE(COUNT('2020 - 2022'[NoEvenement]),'2020 - 2022'[Année financière]="2019-2020",'2020 - 2022'[Période]<6)/5

All the data comes from a single table. 

Please note that I've simplified the DAX function : At the end I need to have a superior and inferior threshold (so i'll have to measure).

Let me know if you need any further information.

Vincent

[Anonymous · Accepted solution]

Hi @vincentllx ,

Please update the formula of your measure [Moy2019] as below and check whether you can get your expected result.

Moy2019 =
DIVIDE (
    CALCULATE (
        COUNT ( '2020 - 2022'[NoEvenement] ),
        FILTER (
            ALLSELECTED ( '2020 - 2022' ),
            '2020 - 2022'[Année financière] = "2019-2020"
                && '2020 - 2022'[Période] < 6
        )
    ),
    5
)

If the above one still can't help you the expected result, please provide some sample data in the table '2020-2022' and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file with me. Thank you.

Best Regards