Forum Discussion

tomperro's avatar
tomperro
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper V rankHelper 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.