Forum Discussion

asdf1608's avatar
asdf1608
Helper V
2 years ago
Solved

Compute Using Table down in table edit calculation in power BI

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.

  • Dangar332's avatar
    Dangar332
    2 years ago

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

     

     

     

3 Replies

    • asdf1608's avatar
      asdf1608
      Helper V
      2 years ago

      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's avatar
        Dangar332
        Resident Rockstar
        2 years ago

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