Forum Discussion
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 in the table object?
Thank you
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.
4 Replies
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.
Hi Gianluigi
If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!Hi Gianluigi ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!Thank you!