DAX Programming for Measures RRS feed

  • Question

  • Hi,

    I have an issue in writing a DAX Program for the following requirement. I have four Measures in Powerpivot Slicers. According the Slicers option selected the data will be displayed in the Value field. Consider 'Measure 1', 'Measure 2', 'Measure 3' and 'Measure 4' present in the slicer. All these four measures comes under single Value field 'Measure'. If i click on the Measure 1 I should get the Average of Measure Values. If i Click on the Measure 2 I should get the Values in Percentage. If i click on the Measure 3 i should get the Sum of Values in the Measure. How to accomplish this using DAX ? Thanks in advance.

    • Moved by Max Meng Monday, May 23, 2011 3:13 PM (From:Excel IT Pro Discussions)
    Friday, May 20, 2011 7:17 PM