locked
substracting a measure from two distinct members of a dimension RRS feed

  • General discussion

  • I have a column in one of the powerpivot tables. it has two distinct values.  What we want to do is have the "total" column in the right hand side of the pivot table display the value of the measure for dimension member # 1 minus the value of the measure for dimension member # 2.  How can I do this in DAX?

    I know I can get a 1 column table with DISTINCT, but how to I associate the context of the measure to the first member of the dimension so I can substract it from the 2nd member?


    Javier Guillen
    Thursday, May 27, 2010 1:59 PM
    Answerer

All replies