This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 91%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Hi,
maybe a simple question, but i'm new with cubes and so on and thererfore i need a little help.
Szenarion:
Dimension Active with values yes and no
Measure:
[Measure].[User]
It works fine but i need a percentage value also e.g.
Date yes % no % Total
01.10. 65 65 35 35 100
Is it possible to get this value with an calculated measure. Or what is the best way for this problem.
Thanks
Armin
Is it a multidimensional (MDX) cube or a tabular cube (DAX); that information is missing?
Sorry - its the multidimensional Version
Hi @DataNinja ,
Could you please show me what is your currently MDX now?
And what format do your want the value be? Quote code from this doc.: using-mdx-to-calculate-both-values-and-percentages-for-analysis-services
Format1:
Format2:
BR,
Mia
If the answer is helpful, please click "Accept Answer" and upvote it.
Wow - thats what i'm looking for.
Thanks a lot :-)
Hi @m
at last one question - this calculations works only with the active Dimension?
If i add another Dimension there is always an error.
Is this correct or is there something wrong with the mdx
with member[Measures].[Percent] as
[Measures].[Users]/
([Nutzung].[Nutzung].currentmember.parent,[Measures].[Users])
select
non empty {[Measures].[Percent] , [Measures].[Users]} ON COLUMNS
, non empty {([Nutzung].[Nutzung].[Nutzung].ALLMEMBERS, [Land].[s Name].&[Deutschland])} on ROWS
from UserActions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 95%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Double-click any cell with #Error to see detailed error message. For this MDX to fail that way, the most likely reason is that the Nutzung attribute hierarchy in the Nutzung dimension is not aggregatable, so no parent exists for either member.