custom calculation of percentage of total and cumulative percentage

genebaldorios
New Contributor II

‎09-17-2025 07:15 PM

Is there a way to calculate the percentage of total using the Databricks dashboard's custom calculations and also the cumulative percentage? What function would be equivalent to the DAX All and AllSelect functions, but using Databricks' aggregation functions through the custom calculation editor? I'm using the custom calculations because using a SQL query would lose the granularity of the data, which would cause errors in the visuals. For example: Sum(value)/sum(value) over()

0 Kudos

szymon_dybczak
Esteemed Contributor III

‎09-18-2025 12:11 AM

Hi @genebaldorios ,

I don't use databricks dashboards on my project (we are PBI shop), but I guess you need to use AGGREGATE OVER clause with cumulative frame:

szymon_dybczak_0-1758179485012.png

 

View solution in original post

0 Kudos

genebaldorios
New Contributor II
In response to szymon_dybczak

‎09-20-2025 06:28 PM

Thanks for the tip, the measurements are as follows:

1. Percentage of Total:

SUM(qty) / (SUM(qty) AGGREGATE OVER (ORDER BY status DESC ALL))


2. Cumulative Percentage SUM(qty) / (SUM(qty) AGGREGATE OVER (ORDER BY status DESC Cumulative))


Calculates the percentage of the cumulative total, sorted by status.

0 Kudos