Analysis Services Live Connection Issue With Table Visual

[morty9091]

Hello. I have a report with live connection to Analysis Services. The report works fine with all the visuals, metrics and dimensions.

I created a report measure,a simple DIVIDE ( [measure1], [measure2],0)  - the measures i'm dividing are part of the cube. When I put that measure on a table visual, there are some metrics from the cube that disappears and is all blank...but if I remove the measure I created, it works fine.

Does anyone know how to sort this out? Thanks.

[jdbuchanan71]

@morty9091 

My guess is, the rows that are being hidden are returning an empty value for your [measure 1].

You can see an example if you DIVIDE ( BLANK(), 10, 0 ) returns a BLANK rather than 0:

[morty9091]

Thanks for your reply, but still doesn t makes sense, is bring null for all rows in that specific measure If I input that divide formula...the funny thing is that it was working before! And i I remove the measure, it brings the values I want instead of blank rows.