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

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

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