Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Calculated Measure

Hi All,   I have a calculated measure which gives me values based on IF condition   Measure5 = IF(Measure1 > Measure2 && Measure3 > Measure4, Measure1,0) When i use this measure for a dimension ...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

Anonymous

 

I guess that you’ve used SUM function in Measure1 to Measure4. According to this article, SUM is only supported in measure when using DirectQuery mode.

If you use Import mode here, you should be able to get the expected result by only changing Measure5 to Column5.

 

 

Best Regards,
Herbert

Anonymous's avatar
Anonymous
Not applicable
10 years ago

yes exactly I've used Calculate and SUM functions in all measures.

Yeah um trying to go for import mode.

thanks for the reply.

I ll get back to you if i have any...!!