Forum Discussion
Display rows only equal to a specific sum amount
Hi All, I'm attempting to create a visual that will display material numbers only when the sum value of accounting transactions is equal to 0, representing the fact that debits and credits for th...
Hi Anonymous ,
Create this measure Filter_0 and filter the visual when the value is 0, like:
Thats how I currently have it structured, the only issue being the user wants the ability to click on any row of the table to have another visual display the associated accounting doc. If a filter is applied as you specified when clicking on the total row of "0" all documents are returned even if the sum total is not 0.
Anonymous ,
So you can apply this filter for the entire page. Does that work ?
the page level filter removes all rows as it's looking for entries with a value of 0 as opposed to a sum of 0, it doesn't appear that works either.