Forum Discussion
Count Items
Hello,
This is question is something that i have done similar in excel the problem is i dont know if it could be done in bi. But better.
I want to create like an index catalogue to know how many items i manage per product line but it goes a bit deeper.
Example Table:
| Item | Product Line | Category | subcategory | Division |
| ad | sport | water sport | diving | snorkle |
| af | sport | water sport | surfing | wax |
| ag | sport | water sport | surfing | surfboard |
| ah | sport | land sport | football | ball |
| aj | sport | land sport | basketball | jersey |
| ak | school & office | school | paint | acrylic |
| al | school & office | office | adhesives | glue |
| zx | school & office | school | paint | oil |
| zc | school & office | school | writing instrument | pencil |
| zv | school & office | office | adhesives | scotch tape |
This is the table. Now using a slicer i want to be able to count :
SLICER:
| Product Line |
| Sport |
| school&Office |
(FOR EXAMPLE IF I CLICK ON SPORTS IT SHOULD SHOW ME)
| Catergory | Count item |
| water sport | 3 |
| land sport | 2 |
( IF I CLICK ON WATER SPORTS ITEMS IT SHOULD SHOW ME)
| Subvategory | Count item |
| Diving | 1 |
| Surfing | 2 |
( IF I CLICK ON THE SURFING ITEMS IT SHOULD SHOW ME)
| Division | Count Item |
| Wax | 1 |
| Surfboard | 1 |
and this would be the end.
Sorry, if this an impossible task just wondering if it could be done.
Thanks in advance
6 Replies
Hi,
I suggest that you create a Matrix visual and drag the last four fields to the row labels. Write this measure
=COUNTA(Data[Item])
Hello,
It works partly.
as in it counts the items but does not get past the prouct line, so the table ends up being like this:
Product Line count Sport 5 School & office 5 Cant filter through it
Hi,
There are filter controls at the bottom right hand side of the visual - see image below
