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

     

     

     

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.

     

     

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      You are using measures.  That may require a rewrite depending on the data model .

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

      I can help you if you provide sample data that fully covers your issue.

      • tomperro's avatar
        tomperro
        Helper V
        3 years ago

        I am unable to attach a file - I do not have that option available and my company is blocking web access to google drive, dropbox, etc.