topic Re: Compute Using Table down in table edit calculation in power BI in DAX Commands and Tips

Compute Using Table down in table edit calculation in power BI

asdf1608 — Tue, 07 Nov 2023 13:22:01 GMT

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

Help in this is needed.

Thanks in advance

Dangar332 — Tue, 07 Nov 2023 13:45:35 GMT

try below

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

asdf1608 — Tue, 07 Nov 2023 14:35:16 GMT

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 — Tue, 07 Nov 2023 15:10:57 GMT

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]) ) )