Forum Discussion
Helper IHow to make a table count values until slicer is selected
Hi, derekli17001
Try the following DAX:
Measure = IF(ISFILTERED('Table'[Customer]), SELECTEDVALUE('Table'[INCLUDE]), COUNT('Table'[INCLUDE]) )In the case that no customer is selected
While choosing a customer to slice
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserNot sure I understand what you want. Can you give us a sample of what your expected results would look like?
Helper IThis is an example of what my current dashboard looks like when no slicer is selected:
When i select a customer on a slicer, i will get a respective yes or no for each item as seen below:
I want it so that when there is no slicer selected - i will get a number of each item for every customer (as shown below) and will only get yes/no when a slicer is selected
I have attached the dataset i used below:
| ITEM | INCLUDE | Customer |
| Appointment as Caltex Distributor | Yes | Kel Campbell |
| Distributor Licensed Area - Selective Zone | Yes | Kel Campbell |
| Sale or assignment | Yes | Kel Campbell |
| Caltex Brand | Yes | Kel Campbell |
| Premises | Yes | Kel Campbell |
| Equipment provided | Yes | Kel Campbell |
| IT System | No | Kel Campbell |
| OPT software and marks | Yes | Kel Campbell |
| Caltex Card | Yes | Kel Campbell |
| Distributor Card | Yes | Kel Campbell |
| Training | Yes | Kel Campbell |
| Contribution to advertising/promotions | Yes | Kel Campbell |
| Investment allowance | Yes | Kel Campbell |
| Service Fee Work | Yes | Kel Campbell |
| Credit/deferred payment terms | Yes | Kel Campbell |
| Commission agency for Depot Front | No | Kel Campbell |
| Appointment as Caltex Distributor | Yes | Bonney |
| Distributor Licensed Area - Selective Zone | Yes | Bonney |
| Sale or assignment | Yes | Bonney |
| Caltex Brand | Yes | Bonney |
| Premises | Yes | Bonney |
| Equipment provided | Yes | Bonney |
| IT System | No | Bonney |
| OPT software and marks | Yes | Bonney |
| Caltex Card | Yes | Bonney |
| Distributor Card | Yes | Bonney |
| Training | Yes | Bonney |
| Contribution to advertising/promotions | Yes | Bonney |
| Investment allowance | Yes | Bonney |
| Service Fee Work | Yes | Bonney |
| Credit/deferred payment terms | Yes | Bonney |
| Commission agency for Depot Front | Yes | Bonney |
| Appointment as Caltex Distributor | Yes | Geraldton |
| Distributor Licensed Area - Selective Zone | Yes | Geraldton |
| Sale or assignment | Yes | Geraldton |
| Caltex Brand | Yes | Geraldton |
| Premises | Yes | Geraldton |
| Equipment provided | Yes | Geraldton |
| IT System | No | Geraldton |
| OPT software and marks | Yes | Geraldton |
| Caltex Card | Yes | Geraldton |
| Distributor Card | Yes | Geraldton |
| Training | Yes | Geraldton |
| Contribution to advertising/promotions | Yes | Geraldton |
| Investment allowance | Yes | Geraldton |
| Service Fee Work | Yes | Geraldton |
| Credit/deferred payment terms | Yes | Geraldton |
| Commission agency for Depot Front | Yes | Geraldton |