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

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 :-)

  • rajdsing's avatar
    rajdsing
    Regular Visitor
    10 years ago

    It only has % of grand total but not the running totals or cumulative sums

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi rajdsing,

      Could you please share sample data of your scenario and post the expected result? To compute running totals or cumulative sums, you can write DAX by referring to the following similar blogs.

      Running Total Techniques in DAX
      Cumulative Total

      Thanks,
      Lydia Zhang