Say I have a table.
| court | activity | amount |
|---|---|---|
| a | 1 | 10 |
| b | 1 | 20 |
| c | 2 | 10 |
| a | 1 | 15 |
| b | 1 | 20 |
| c | 2 | 15 |
| d | 2 | 10 |
| d | 3 | 25 |
| c | 3 | 30 |
| a | 1 | 15 |
Say I have a table.
| court | activity | amount |
|---|---|---|
| a | 1 | 10 |
| b | 1 | 20 |
| c | 2 | 10 |
| a | 1 | 15 |
| b | 1 | 20 |
| c | 2 | 15 |
| d | 2 | 10 |
| d | 3 | 25 |
| c | 3 | 30 |
| a | 1 | 15 |
I have two single-selected slicers based on court and activity respectively. Activity slicer will filter court slicer but court slicer will not filter activity slicer.
I would like to have a card visual displaying the number of rows of the table by removing the court filtering but keeping the activities filter.
Suppose one selected court = 'd' and activity = '3'. When activity slicer change from '3' to '1', I would like to have the card to show 2, even though there is no such combination in the table.
Disabling the interaction between the card visual between the court slicer and the card is not allowed based on my report.
Share Improve this question edited Mar 31 at 13:16 Michael asked Mar 31 at 9:46 MichaelMichael 311 silver badge5 bronze badges 2- Shouldn't the number of rows in the table be 5 when filtered on 'activity = 1', and not 3? – Marco Vos Commented Mar 31 at 12:05
- @MarcoVos Thank you for answering. Yes, you are right. But I found the issue I encountered was more complicated than what I described previously when I tried to translate my issue into this toy example so I provided more detail. The solution you provided could not address this case. – Michael Commented Mar 31 at 13:20
1 Answer
Reset to default 0Try using a measure like:
Measure = CALCULATE ( COUNTROWS ( 'Table' ), ALL ( 'Table'[court] ) )
and put it on the card visual. This will ignore the 'court' slicer.