Forum Discussion

derekli17001's avatar
derekli17001
Icon for Helper I rankHelper I
2 years ago
Solved

How to make a table count values until slicer is selected

This is my excel sheet On my dashboard- i have 3 customers and the same items with varying conditions of either yes or no. I want it so that when no slicers for specific customers (column c) a...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

ToddChitt's avatar
ToddChitt
Icon for Super User rankSuper User
2 years ago

Not sure I understand what you want. Can you give us a sample of what your expected results would look like?

  • derekli17001's avatar
    derekli17001
    Icon for Helper I rankHelper I
    2 years ago

    This 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:

    ITEMINCLUDECustomer
    Appointment as Caltex DistributorYesKel Campbell
    Distributor Licensed Area - Selective ZoneYesKel Campbell
    Sale or assignmentYesKel Campbell
    Caltex BrandYesKel Campbell
    PremisesYesKel Campbell
    Equipment providedYesKel Campbell
    IT SystemNoKel Campbell
    OPT software and marksYesKel Campbell
    Caltex CardYesKel Campbell
    Distributor CardYesKel Campbell
    TrainingYesKel Campbell
    Contribution to advertising/promotionsYesKel Campbell
    Investment allowanceYesKel Campbell
    Service Fee WorkYesKel Campbell
    Credit/deferred payment termsYesKel Campbell
    Commission agency for Depot FrontNoKel Campbell
    Appointment as Caltex DistributorYesBonney
    Distributor Licensed Area - Selective ZoneYesBonney
    Sale or assignmentYesBonney
    Caltex BrandYesBonney
    PremisesYesBonney
    Equipment providedYesBonney
    IT SystemNoBonney
    OPT software and marksYesBonney
    Caltex CardYesBonney
    Distributor CardYesBonney
    TrainingYesBonney
    Contribution to advertising/promotionsYesBonney
    Investment allowanceYesBonney
    Service Fee WorkYesBonney
    Credit/deferred payment termsYesBonney
    Commission agency for Depot FrontYesBonney
    Appointment as Caltex DistributorYesGeraldton
    Distributor Licensed Area - Selective ZoneYesGeraldton
    Sale or assignmentYesGeraldton
    Caltex BrandYesGeraldton
    PremisesYesGeraldton
    Equipment providedYesGeraldton
    IT SystemNoGeraldton
    OPT software and marksYesGeraldton
    Caltex CardYesGeraldton
    Distributor CardYesGeraldton
    TrainingYesGeraldton
    Contribution to advertising/promotionsYesGeraldton
    Investment allowanceYesGeraldton
    Service Fee WorkYesGeraldton
    Credit/deferred payment termsYesGeraldton
    Commission agency for Depot FrontYesGeraldton