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

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.

  • tomperro's avatar
    tomperro
    Helper V
    3 years ago

    Even looking at your pbix file, I am seeing that the numbers are not showing what I need.

    I need a combination of what you have and what I have.

     

     

    • lbendlin's avatar
      lbendlin
      Super User
      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 
      ) 
    )