Forum Discussion

cryanderson's avatar
cryanderson
Regular Visitor
8 years ago
Solved

Measurement crashes after it gets too long

I'm showing Power BI keeps crashing after my measurement formula gets too long. I'm trying to calculate a score based on our Index measurement, and it'll work until I write past 15 rules then it starts crashing. 

Score = if([Index]>149,70,(if(AND([Index]<150,[Index]>147),69,(if(and([Index]<148,[Index]>145),68,(if(and([Index]<146,[Index]>143),67,(if(and([Index]<144,[Index]>141),66,(if(and([Index]<142,[Index]>139),65,(if(and([Index]<140,[Index]>137),64,(if(AND([Index]<138,[Index]>135),63,(if(AND([Index]<136,[Index]>133),62,(if(AND([Index]<134,[Index]>131),61,(if(AND([Index]<132,[Index]>129),60,(if(and([Index]<130,[Index]>127),59,(IF(AND([Index]<128,[Index]>125),58,(if(and([Index]<126,[Index]<123),57,(if(and([Index]<124,[Index]>121),56,(if(and([Index]<122,[Index]>119),55,(if(and([Index]<120,[Index]>117),54,(if(and([Index]<118,[Index]>115),53,(if(and([Index]<116,[Index]>113),52,(if(and([Index]<114,[Index]>111),51,(if(and([Index]<112,[Index]>109),50,(if(and([Index]<110,[Index]>107),49,(if(and([Index]<108,[Index]>105),48,(if(and([Index]<106,[Index]>103),47,(if(and([Index]<104,[Index]>101),46,(if(and([Index]<102,[Index]>99),45,(if(and([Index]<100,[Index]>97),44,(if(and([Index]<98,[Index]>95),43,(if(and([Index]<96,

  • Anonymous's avatar
    Anonymous
    8 years ago

    cryanderson,

    Use the DAX instead.

    Column = SWITCH(TRUE(),
Table[Index]>149, 70,
Table[Index]<150 && Table[Index]>147,69,
Table[Index]<148 && Table[Index]>145,68,
Table[Index]<146 && Table[Index]>143,67,
Table[Index]<144 && Table[Index]>141,66,
Table[Index]<142 && Table[Index]>139,65,
Table[Index]<140 && Table[Index]>137,64,
Table[Index]<138 && Table[Index]>135,63,
Table[Index]<136 && Table[Index]>133,62,
Table[Index]<134 && Table[Index]>131,61,
Table[Index]<132 && Table[Index]>129,60,
Table[Index]<130 && Table[Index]>127,59,
Table[Index]<128 && Table[Index]>125,58,
Table[Index]<126 && Table[Index]>123,57,
Table[Index]<124 && Table[Index]>121,56,
Table[Index]<122 && Table[Index]>119,55,
Table[Index]<120 && Table[Index]>117,54,
Table[Index]<118 && Table[Index]>115,53,
Table[Index]<116 && Table[Index]>113,52,
Table[Index]<114 && Table[Index]>111,51,
Table[Index]<112 && Table[Index]>109,50,
Table[Index]<110 && Table[Index]>107,49,
Table[Index]<108 && Table[Index]>105,48,
Table[Index]<106 && Table[Index]>103,47,
Table[Index]<104 && Table[Index]>101,46,
Table[Index]<102 && Table[Index]>99,45,
Table[Index]<100 && Table[Index]>97,44,
Table[Index]<98 && Table[Index]>95,43,
Table[Index]<96 && Table[Index]>93,42,
Table[Index]<94 && Table[Index]>91,41,
Table[Index]<92 && Table[Index]>89,40,
Table[Index]<90 && Table[Index]>87,39,
Table[Index]<88 && Table[Index]>85,38,
Table[Index]<86 && Table[Index]>83,37,
Table[Index]<84 && Table[Index]>81,36

)



    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    cryanderson,

    Use the DAX instead.

    Column = SWITCH(TRUE(),
Table[Index]>149, 70,
Table[Index]<150 && Table[Index]>147,69,
Table[Index]<148 && Table[Index]>145,68,
Table[Index]<146 && Table[Index]>143,67,
Table[Index]<144 && Table[Index]>141,66,
Table[Index]<142 && Table[Index]>139,65,
Table[Index]<140 && Table[Index]>137,64,
Table[Index]<138 && Table[Index]>135,63,
Table[Index]<136 && Table[Index]>133,62,
Table[Index]<134 && Table[Index]>131,61,
Table[Index]<132 && Table[Index]>129,60,
Table[Index]<130 && Table[Index]>127,59,
Table[Index]<128 && Table[Index]>125,58,
Table[Index]<126 && Table[Index]>123,57,
Table[Index]<124 && Table[Index]>121,56,
Table[Index]<122 && Table[Index]>119,55,
Table[Index]<120 && Table[Index]>117,54,
Table[Index]<118 && Table[Index]>115,53,
Table[Index]<116 && Table[Index]>113,52,
Table[Index]<114 && Table[Index]>111,51,
Table[Index]<112 && Table[Index]>109,50,
Table[Index]<110 && Table[Index]>107,49,
Table[Index]<108 && Table[Index]>105,48,
Table[Index]<106 && Table[Index]>103,47,
Table[Index]<104 && Table[Index]>101,46,
Table[Index]<102 && Table[Index]>99,45,
Table[Index]<100 && Table[Index]>97,44,
Table[Index]<98 && Table[Index]>95,43,
Table[Index]<96 && Table[Index]>93,42,
Table[Index]<94 && Table[Index]>91,41,
Table[Index]<92 && Table[Index]>89,40,
Table[Index]<90 && Table[Index]>87,39,
Table[Index]<88 && Table[Index]>85,38,
Table[Index]<86 && Table[Index]>83,37,
Table[Index]<84 && Table[Index]>81,36

)



    Regards,
    Lydia

    • cryanderson's avatar
      cryanderson
      Regular Visitor
      8 years ago

      Perfect that worked without any issues. Thank you!