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.
Hi,
I am working with an Multidimensional OLAP Cube, and I have 3 calculated measures as follow:
CREATE MEMBER CURRENTCUBE.[Measures].[Depense] AS ([Measures].[BUDGET],[DIM TYPE DEPENSE].[LIBELLE TYP MVT].&[Depense]) CREATE MEMBER CURRENTCUBE.[Measures].[Recette] AS ([Measures].[BUDGET],[DIM TYPE DEPENSE].[LIBELLE TYP MVT].&[Recette]) CREATE MEMBER CURRENTCUBE.[Measures].[Effort] AS 1-([Recette]/[Depense])
For the last one i get as results all the years of the date dimension with null value as well as the right value for the related years.
Anyone can give me a hint or a way to eliminate the unwanted null value ?
Kind regards,
Mohammad
Hi @Anonymous,
As this thread is more related to SQL Server Analysis Service, please post your question on relative forum so that you can get more professional advice.
Thanks,
Yuliana Gu
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |