Help with counting behavior

[WDarwish]

Apologies if the subject is not 100% clear - it is difficult to describe as English is not my native language.

I have a simplified data set that represents my problem. Also attached sample PBIX.

Sample PBIX

Source ID	Row ID	Value	Is Visible?
A	A	10	False
A	A	20	True
A	B	3	True
B	C	4	True
B	C	7	False
B	D	1	True
B	D	6	False
B	D	11	False

I want to create the following behavior in Power BI:

• Display ONLY visible items in a table (achieved with visual-level filter)
• Display a card visual containing the number of invisible items
• When clicking on a row in the table, have the card visual update to the number of invisible items from the same Source ID and Row ID

So opening the Power BI with no selections would give count of invisible = 4. But clicking on first row (A, A), counter should update to 1 (in attached it goes BLANK). Clicking on row (A,B) should give 0. Row (B, C) should give 1. Row (B,D) should give 2.

I am trying to build this in, but no matter what I try, cross-filtering gives BLANK in the counter. For example, in below screenshot, I want it to give 2.

This is an oversimplified example, so the solution will be retrofitted into the original report.

Please help? Thanks.

[parry2k · Accepted solution]

@WDarwish for card, add this following measure and you don't need visual level filter on card whcih you currently have.

Invisible Count = 
CALCULATE( COUNTROWS( 'Sample' ), NOT 'Sample'[Is Visible?] )  

[parry2k · Accepted solution]

@WDarwish for card, add this following measure and you don't need visual level filter on card whcih you currently have.

Invisible Count = 
CALCULATE( COUNTROWS( 'Sample' ), NOT 'Sample'[Is Visible?] )  

[WDarwish]

Is it really this simple? Are you a magician? 😄

Seriously though, do you mind explaining the logic of how it works? I understand the individual functions used in the measure, but I do not understand how they combine to filter out data and count only rows of concern.

[parry2k · Accepted solution]

@WDarwish Basically that measure is saying just ignore any filter on Is Visible  and just count where Is Visible is False