Matrix rows not filtering properly

[javigold]

I have a matrix:

So my model is Region 1 - many on Programs.   Programs 1 - many on Activities.   

2 measures:

# of Programs= CALCULATE(COUNT('Programs'[Id]))

# of Activities= CALCULATE(COUNT('Activities'[Id]))

How do I filter out rows of activities that aren't associated with the program??

Thx!

[grantsamborn]

Hi @javigold 

If you have a many-to-one relationship between Programs and Activities, it should be easy to find any activities that aren't associated with a program.

Could you show:

(a) sample source dataset

(b) your expected end result

(c) a description of how you would expect to get from (a) to (b).

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Thanks,

Grant

[javigold]

Yeah, realized I didn't really get enough info in the question to make sense.  😉

So, my data model is this:

And the matrix ends up like this: 

My data tables are: 

What I am expecting is for the activities to only show up in a matrix row when they have a count of 1 or more.   Hopefully, that makes more sense. 

[bolfri · Accepted solution]

Click on the table and open filter pane. Then with measure # of Activities go to advanced and select option "is not blank". That's it. 🙂

[grantsamborn]

Hi @javigold 

Thanks for the additional info.

Is there any way you can copy the source data as described in the following link?   It makes any troubleshooting mush easier.

A pbix with sample data would be ideal.

Here are the links again.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Thanks,

Grant