what you want to evaluate and if [Consommation Moyenne] is a hierarchy

Question

hello how to calculate kpi with iff for exemple if IIF ([Measures].[Consomation Energie]) >[Dim Consommation Moyenne].[Consommation Moyenne] msg bad consumption else good consumption

Answer 1

Try the following

IIF ([Measures].[Consomation Energie] > [Dim Consommation Moyenne].[Consommation Moyenne],
     "bad consumption",
     "good consumption")