Please help: Deeper Sum Formula

I have a big table, data is: ----------------------------------------- Date City Store Product Price Jan 01 Toronto A ...

amitchandak
2 years ago
Anonymous ,

One is

Total Price = Sum(Table[Price])

another is

Total Price City = calculate(Sum(Table[Price]), removefilters(Table[Store]) )

or

Total Price City = calculate(Sum(Table[Price]), filter(allselected(Table),Table[Store] = max(Table[Store]) ) )

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=24270s
Anonymous
2 years ago
I use
Deno = Calculate(SUM('Table'[Price]), ALLEXCEPT('Table', 'Table'[Date], 'Table'[City]))
to get the following picture:

Anonymous

Not applicable

2 years ago

amitchandak , Thank you very much for your reply. I tried all formula you gave. Name them as D1, D2, D3. The picture I got is:

What I want is a ratio. Now I am looking for a denominator.

In the above picture, column 2 is the closet column to the solution.

I need a picture replace 600, 650 with 1250 and replace 500, 550 with 1050.

Anonymous

Not applicable

2 years ago

I use

Deno = Calculate(SUM('Table'[Price]), ALLEXCEPT('Table', 'Table'[Date], 'Table'[City]))

to get the following picture:

Forum Discussion