Forum Discussion
Help with counting behavior
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.
| 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.
3 Replies
Is it really this simple? Are you a magician? :D
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.
