Forum Discussion

kg4u's avatar
kg4u
Icon for Helper II rankHelper II
3 years ago

How to divide column totals

Hi,   I have looked through this forum and searched online but cannot find a solution for what I think is an easy problem.  Below is my data table, and I simply would like a measure that will calcu...
Need Help
Show and Tell
Tips and Tricks
justingraff88's avatar
justingraff88
Icon for Helper I rankHelper I
3 years ago

should be able to just do a measure like below and change it to a %

 

  • kg4u's avatar
    kg4u
    Icon for Helper II rankHelper II
    3 years ago

    justingraff88 Not quite what I am looking for.  I want to divide the column totals (5,161.3/4392.7)

    • justingraff88's avatar
      justingraff88
      Icon for Helper I rankHelper I
      3 years ago

      It will display at the level it is at. So the total (117.50%) is the total of the columns divded by each other. If you don't want to display it with the different product levels showing I would recommend just putting the measure into a card visual (this would be the easiest way).

       

      Alternatively you could just change the text and background of that column in the table to essentially hide the values

       

  • kg4u's avatar
    kg4u
    Icon for Helper II rankHelper II
    3 years ago

    justingraff88 The only problem is I don't have a 'Table'.  The picture in my example is a table visual.  How do I pick up the total from the value from the visual table?  I can't create the calc you suggested as I don't have an actual table.   Do you have any other ideas for me to try?

    • justingraff88's avatar
      justingraff88
      Icon for Helper I rankHelper I
      3 years ago

      kg4u Can you post a copy of your pbix?