Forum Discussion
"Compute Using" option
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 :-)
Matt,
Is there a simple way of calculating the running total... I am also trying to draw a pareto chart
rajdsing That is a complicated question. I received help from a community member on this. It was successful. Here is the link.
Quick and Versatile are often strangers. Power BI is very versitile, but not so quick. You can write a formula for a running total like this.
=calculate(sum(table[qty],
filter(all(calendar),
calendar[date] <= max(calendar[date])
)
)this may or may not be what you are after I guess, but it will create a running total.
If you read my book and do the exercises, you will be on your way to becoming a DAX Ninja :-)
