calculated measure instead of calculated dimension

[sjar1290]

Hi All,

I am using a calculated dimension if(Field=column1 and Field<>column2, user ID, null()) , and I want to exclude the null values

if I use the same expression as measure its giving me all null values

by using the calculated dimension the APP becomes very slow and talking so much of time to load the data

is there any way that we can replace the above expression with some other expression and exclude the null values and load the data fast.

any help would be much appreciated.

Thank you!

[Mark_Little]

HI @sjar1290 

What is the actual Expression you are using? If statements are slower than set analysis. 

When I have faced these issue in the past I look to move the heavy lift to the script. It might be adding a flag or a new dimension you can use in your set expression.

[vinieme12]

just create this field in your load script!