Forum Discussion
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. ...
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 ) )
