Forum Discussion

tomperro's avatar
tomperro
Helper V
3 years ago
Solved

Table Visualization Totals Help

Having some difficulty figuring out how to get the total (in red) that I need to show. I am getting 3159 not 926. 3159 is the Total This divided by Total That - should be 3,159 divided by 13 = 926. ...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

     

     

     

    This per That = 
  IF(
    HASONEVALUE('Table'[Category]),
    DIVIDE(
      SUM('Table'[Total This]),
      SUM('Table'[Total That]),
      0 
      ),
    DIVIDE(
      SUMX('Table', DIVIDE('Table'[Total This], 'Table'[Total That], 0)),
      SUMX('Table', 'Table'[Total That]),
      0 
      ) 
    )

     

     

     

lbendlin's avatar
lbendlin
Super User
3 years ago

DIVIDE(SUMX([Total This]/[Total That]),SUMX([Total That]),0)

 

Note that this will be confusing to your users as you are switching between simple division and squared division.  This pattern (weighted averages) usually involves multiplication, not division.

  • tomperro's avatar
    tomperro
    Helper V
    3 years ago

    This is not working.

    I am receiving NaN.

    Also, Sumx requires table name as first parameter.

     

    I 

      • tomperro's avatar
        tomperro
        Helper V
        3 years ago

        Thank you. I see it is working in your pbix file.

        In your file you have this:

         

        but in my file I have a calculator symbol next to those fields, would that make a difference?

         

        I am using sensitive data, so I can not share my file.