Forum Discussion

vincentllx's avatar
vincentllx
Regular Visitor
4 years ago
Solved

Constant Threshold calculation

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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