dax measure problem in excel?

[Anonymous]

Whenever I consume my model from excel, if I put the next measure it crashes:

Measure1:=

IF

(

NOT [Measure1] < 0,

DIVIDE ( [Measure2], [Measure1])
)

Why is this happening?

(it works fine in power bi desktop)

[v-chenwuz-msft]

Hi @Anonymous ,

Are you sure it works fine in power bi? The [Measure1] can't be divided itself or use itself in its definition expression.

Measure1:=

IF

(

NOT [Measure1] < 0,

DIVIDE ( [Measure2], [Measure1])
)

I think you should want to calculate certain values cumulatively. If so, you can refer to a similar blog.

The CALCULATE Function In Power BI - DAX Tutorial - Microsoft Power BI Community

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , a model working in power bi should work in excel. Hope we are taking of power bi dataset?

IF

(

[Measure1] <>  0,

DIVIDE ( [Measure2], [Measure1])
)

or

DIVIDE ( [Measure2], [Measure1])