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 star...
  • 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