Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |