Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Like "Compute Using" option is present in tableau for doing calculations across table, across pane etc, is there any similar feature in power bi?
Can you describe the behaviour of "compute using". I have never heard of it.
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
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
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 🙂
@rajdsing That is a complicated question. I received help from a community member on this. It was successful. Here is the link.
Proud to be a Super User!
There is also a new quick calc feature on some visuals. I blogged about that here
http://exceleratorbi.com.au/power-bi-may-2016-update-another-cracker/
It only has % of grand total but not the running totals or cumulative sums
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |