Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have up to 10 measures and only one dimension
I’m trying to figure out how to make this work.
the one that works can only have 1 measure.
I think maybe my chart was not setup correctly?
im not able to upload an example but I want to ask what I am missing here. Thanks!
What you are missing here is a lot of details about your problem. What are you trying to accomplish? what is not working, etc...
If you are trying to build a stack bar chart, then you need to have 2 Dimensions and 1 Measure. So, if you only have one dimension and up to 10 measures, then you need to convert your multiple measures into one, using a synthetic dimension.
Create a synthetic dimension using ValueList() and then make a multiple choice condition in your measure, with the appropriate expressions for each value in the list.
Cheers,
Oleg Troyansky
May be try this
Sum(Sales) /
Sum(TOTAL <Area> Sales
)