Compute Using Table down in table edit calculation in power BI

[asdf1608]

I am trying to do a DAX Calculation in Power BI - but it doesn't work like it does in Tableau and I can't figure out what I am doing wrong.

Calculations I am using in Tableau Listed Below

Table Down  = Sum(Sales)/Total(Sum(Sales))

The result for the above calculation is obviously 1

I got the same in Power BI.

But there is an option in Tableau called Table(down)

After selecting as Table(Down), the values of Tableau gets changed.

  

How do I achieve this table down in power BI. 

I tried to use Calculate but still I didn't get what I need in Power BI

samplea.pbix

I'm attaching the sample file here both tableau and Power BI for reference

In Tableau the table(down) Computes down the length of the table and restarts after every partition.

For example, in the following table, the calculation is computed down rows (MONTH(Order Date)) for e...

 

Help in this is needed.

Thanks in advance

[Dangar332]

hi, @asdf1608 

try below

Column = DIVIDE(Sheet1[Sales],SUMX(ALL(Sheet1),Sheet1[Sales]))

[asdf1608]

@Dangar332 Yes I have tried that. it just gives me answer as "1"

What I want was to calculate table down for that column which provides this answer

This is the expected result I need in power BI

[Dangar332 · Accepted solution]

hi, @asdf1608 

same as you want 

it is column not a mesure

Column = DIVIDE(Sheet1[Sales],SUMX(ALL(Sheet1),Sheet1[Sales]))

output in measure

Measure = DIVIDE(
      SUM(Sheet1[Sales]),
      CALCULATE(
         SUM(Sheet1[Sales]),
         REMOVEFILTERS(Sheet1[Document Number])
      )
   )