Greetings, I am trying to recreate a calculation in QuickSight that I once had in Power BI. I have my total customers, which are segregated into various levels as shown below. When I take a simple sum of my members, it automatically splits the number by the levels. However, in the third column, the …

Hi @vkedia Please try sumOver ensures that the sum is computed across all rows (ignoring the level or any filters applied). Example: (Syntax may differ - replace the fields from your dataset). sumOver( {no_of_members}, [], PRE_AGG )

Replicating a power bi calculation using ALLSELECTED

Question & Answer

Giridhar.Prabhu December 13, 2024, 11:29am 3

Hi @vkedia

You can use the sumOver function. An example is provided below

Use the article below for further reading

1 Like