Forum Discussion
Measure controlled by Dimension
Hello all, I have an OLAP cube with multiple values contained within one measure, controlled by a dimension. For example, I have a measure called VALUE which contains Revenue, Budget or Orders - ...
Thanks for the reply - in your example, how would you plot (within PowerBI) a guage that showed Actual versus Budget?
cheers
Chris
I thought you were asking for a gauge that you could control with a slicer, where it would switch between showing actual and budget. If you want to plot actual against budget on a gauge, why would you not just write a measure for actual and a measure for budget, then put them both on the gauge?
Agreed - the issue is that we already have a cube with the measures developed the way they have been, we can use this method within Pyramid Analytics as it allows that granularity of selection but did wonder if
a) PowerBI could handle it and
b) Whether many other people constructed their measures this way
cheers
Chris