Forum Discussion
Solved
locking only one column in a table visual
Is it possible to lock only one column in a table visual from filtering given by a slicer?
My data look like this:
| Data | ||
| Farm | Products | Fail |
| Farm A | product A | x |
| product A | y | |
| product B | ||
| product C | x | |
| product D | ||
| product E | x | |
| product E | x | |
| product E | y | |
| product F | ||
| product H | ||
| Farm B | product A | x |
| product B | y | |
| product C | y | |
| product D | ||
| product E |
Customer wants a dropdown slicer(filter) on Fail Type X/Y and desired result should look like this:
| Desired Visual without filtering | |||
| Farm | # of Products | Fails | Products Affected |
| Farm A | 7 | 6 | 3 |
| Farm B | 5 | 3 | 3 |
| Desired Visual after filtering on Type of Fail | |||
| Filter on Fail X | |||
| Farm | # of Products | Fails | Products Affected |
| Farm A | 7 | 4 | 3 |
| Farm B | 5 | 1 | 3 |
| Filter on Fail Y | |||
| Farm | # of Products | Fails | Products Affected |
| Farm A | 7 | 2 | 2 |
| Farm B | 5 | 2 | 2 |
Is there a way to reach this with my kind of data? Or how should I modify them to obtain the result.
Thank you.
AndreaSo , Create # of product with removefilters
calculate(countrows(Table), removefilters (Table[Type]) )
2 Replies
AndreaSo , Create # of product with removefilters
calculate(countrows(Table), removefilters (Table[Type]) )
works, thank you
