Forum Discussion
Solved
table display object
Hi, I have created a table view object with several columns. One column is a measure. I would like the measure not to total. Is this possible without having to remove the total from all the columns ...
You can modify the measure to check whether it is in the total row or not. If you have 'Table'[Column 1] in your table visual then you could use e.g.
My Sum = IF ( ISINCOPE ( 'Table'[Column 1] ), CALCULATE ( SUM ( 'Table'[Column 2] ) ) )So when the measure is calculated for individual rows it will return a value, but it will return blank in the total row.
You can modify the measure to check whether it is in the total row or not. If you have 'Table'[Column 1] in your table visual then you could use e.g.
My Sum =
IF ( ISINCOPE ( 'Table'[Column 1] ), CALCULATE ( SUM ( 'Table'[Column 2] ) ) )
So when the measure is calculated for individual rows it will return a value, but it will return blank in the total row.