Forum Discussion

MSoranno's avatar
MSoranno
Frequent Visitor
6 years ago

Toggle between "Show Values As"

Hello, I have a matrix with Sales Manager along the rows and Ship Methods along the columns. I use a Measure called "Unique Orders" populating the values.   I would like to be able to toggle bet...
Need Help
Tutorial Requests
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

MSoranno you can create a conditional measure for example like this, I hope this is what you are asking for.

 

Show Value As = 
IF ( SELECTEDVALUE ( Table[Option] ) = "Sum", 
SUM ( Table[Amount] ),
AVG ( Table[Amount] )
)

 

MSoranno's avatar
MSoranno
Frequent Visitor
6 years ago

Hi Parry2k,

Unfortunately, this doesn't really provide enough details to help me, nor does it seem to address my issue. I'm trying to toggle between % of Row Total & the Original Value, not the average vs. sum.

 

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    MSoranno  sum and avg was just an example calculation, on your selection you can write your own calculation. Let me know how else I can help.

    • MSoranno's avatar
      MSoranno
      Frequent Visitor
      6 years ago

      Hi Parry2K,
      I know, but there's a distinction from what I'm trying to do. I have the count of unique orders, and I want that count shown in the matrix, but I want the option to toggle between that value and the % of the row total, which is a selection you can do in the "Show Values as" that requires no modification to the formula, but just how it's shown.