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)
Hi TeroK ,
Add a filter on the visual.
Or create a measure.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for your proposal but that does not work.
By filtering only common there are still the types that have been using others as well. It just filters the other rows away.
The thing was that I want the types that use only Common module. If you check my attached picture you might get my idea. In that picture there are two types that I would like to be left after filtering.
Those are these:
004179e4772fecfd918bdfcf9465b330187fb7a57b2267f6607a39a37d442141
00511d1cad6fb6c4d58911696b811f6b2765ca310bd7d69ccf3acc3c4e2282d7
Thanks.
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.