Forum Discussion
How to filter a column based on a another column
Place the type in a table visual
Create a measure that:
contains the type in a variable _type
counts the rows that have the module - Common and type - _type <- put in a variable C
counts the rows that have the module is not equal to Common and type _type <- put in a notC variable
if C >0 and notC to 0, returns 1 (to indicate true, you can display or filter it)
Place the type in a table visual
Create a measure that:
contains the type in a variable _type
counts the rows that have the module - Common and type - _type <- put in a variable C
counts the rows that have the module is not equal to Common and type _type <- put in a notC variable
if C >0 and notC to 0, returns 1 (to indicate true, you can display or filter it)
Big thanks, I got it working with your suggestion.