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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Nurzh_17
Frequent Visitor

Filter rows in a table with conditions to a group of values

Hi Community, 

I have a table called Concurrent Documents. 

 

Nurzh_17_0-1683017744726.png

As you might have seen from above screen, every Drawing Number divided into Master and Copy(bold and grey) and inside one Master Drawing Numbers there can be several copies. 

If Document Category in {Master Document, Project Document} it is Master, If Document Category in {Project Working Copy, Working Copy} it is Copy

The task is that I need to display on table visual Master Drawing Numbers with their copies, however ALL Copy numbers ,must be in Reason for Issue = Z - As Built. 

And no matter what status have the Master Document. 

 

For example, in above screen first Master Document 010-0700-JJJ-LAY-20001-03 have copies with Reason For Issue not Z - As Built and we don't need this rows. All copies need to be in Z - As Built. Just like this example: 

 

Nurzh_17_1-1683018756013.png

 

Hope I explained correctly, 

Thank you for your help! 

 

 

6 REPLIES 6
tamerj1
Super User
Super User

Hi @Nurzh_17 

place the following message in the filter pane of the matrix visual, select "is not blank" then apply the filter

FilterMeasure =
COUNTROWS (
FILTER (
'Concurrent Documents',
'Concurrent Documents'[Document Category]
IN { "Master Document", "Project Document" }
|| 'Concurrent Documents'[Reason] = "Z - As Built"
)
)

Hi @tamerj1 , 

In this case i get the Master Documents that appears without copies. 

In first table I placed the filter, and second as it is. 

Nurzh_17_0-1683023800456.png

How should I exclude this Master Documents that occurs alone, I need to display values only with existing Copies that equal to 'Concurrent Documents'[Reason] = "Z - As Built".

@Nurzh_17 

Would you please paste a screenshot of the dax code that you have used?

@tamerj1 
Here the screen, could you check please 

Nurzh_17_0-1683029180302.png

 

 

@Nurzh_17 

Please try

FilterMeasure =
COUNTROWS (
FILTER (
'Concurrent Documents',
'Concurrent Documents'[Reason] = "Z - As Built"
)
)

@tamerj1 

Now this do the same but ignoring Master Document that have other Reason for Issue Status. 

Nurzh_17_0-1683029526229.png

I need to display Masters with their copies which have Reason = Z and if Master Document even have one Copy in another Reason then we need to exlcude all rows with Master Document also🙂

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors