Forum Discussion
Emmy66
Helper V
Helper VCreate a table to hold 2 Measures
Hi, I'm trying to create a clustered bar chart where I have 10 measures. My intention is to have 2 of the measures grouped or stored in a table so that there will be spaces between each pair. curre...
Emmy66Helper V
Helper VHi fhill , thanks for your response. Very much appreciated. What you illustrated is exactly what I intend to achieve. Like you mentioned, that I should create a measure of one set of bars (how do I accomplish that please?) Currently I have 10 measures that are dynamically calculated (all expressed in %) which I've created e.g. the measures are based on the calculation below.
I have 6 other measures calculated in same manner. The measures with prefix Partners_Only (represents the purple bar) and the prefix All_users (represents the green bar). With the above measures, how do I implement your suggestion please bearing in mind that the measures are not held in any table but calculated on the fly?
fhill
Resident Rockstar
Resident RockstarIn my example, the 2 Measures have filters of the source data that allow both sets of data to be displayed on the same chart without overlap (Legend).
It looks like your example measures are DIVIDING other measures? You'll need to post an example of your source data for us to help you with the actual Measure code.