Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TeroK
Frequent Visitor

How to filter a column based on a another column

Hello all,

 

I'm trying to solve an issue but cannot get my head around the problem so hopefully you are able to help me out.

My problem is to find from the data the types that use only common module and nothing else.
So for example from sample below This type: 004179e4772fecfd918bdfcf9465b330187fb7a57b2267f6607a39a37d442141. That has been using only Common. Other types have been using common also but also others.

 

TeroK_1-1601038292124.png

Seems an easy filtering but I just could not figure out how to. 

 

Thank you.

1 ACCEPTED SOLUTION

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)

View solution in original post

4 REPLIES 4
v-lionel-msft
Community Support
Community Support

Hi @TeroK ,

 

Add a filter on the visual.

v-lionel-msft_0-1601284384746.png

Or create a measure.

v-lionel-msft_1-1601284513279.png

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.