Forum Discussion
cryanderson
8 years agoRegular Visitor
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...
- Anonymous8 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
Anonymous
8 years agoNot applicable
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
8 years agoRegular Visitor
Perfect that worked without any issues. Thank you!