Forum Discussion

rajdsing's avatar
rajdsing
Regular Visitor
10 years ago

"Compute Using" option

Like "Compute Using" option is present in tableau for doing calculations across table, across pane etc, is there any similar feature in power bi?
MattAllington's avatar
MattAllington
Community Champion
10 years ago

Can you describe the behaviour of "compute using". I have never heard of it. 

  • rajdsing's avatar
    rajdsing
    Regular Visitor
    10 years ago

    For example when you are calculating the percentage of grand totals, you have options in tableau to compute it using the "Compute USing" across rows, columns, or Pane etc. See the image attached to get an idea of all the options.

     

    e Using" function

    • MattAllington's avatar
      MattAllington
      Community Champion
      10 years ago

      The CALCULATE function allows you to change the filter context in any report.  Using this tool, you can create virtually anything you need. An example is a simple table

       

      Year.   Qty

      2001. 10

      2002.  15

      total.   25

       

      To get each row percentage of total, you would write something like

       

      =divide(sum(table[Qty]),calculate(sum(table[qty]),ALL(table[year])))

       

      but out it is a big topic :-)