Forum Discussion

steambucky's avatar
steambucky
Helper III
8 years ago
Solved

How do user a SLICER on a count?

The short question is - how would slice a count?   My company is trying to view trends in the type and amount of datasets that our customers are downloading.   We have becoming interested in cust...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi steambucky

    Sorry for releying late, please look at my file.

    calculated column

    count of email address = CALCULATE(DISTINCTCOUNT(Sheet2[email address]),ALLEXCEPT(Sheet2,Sheet2[data download]))

    select "don't summarize", instead of any aggreation.

     

    Best Regards

    Maggie

  • RA_gov's avatar
    RA_gov
    7 years ago

    How would I add a count as an additional field in a slicer?

    I have a map report with properties in US states.  My current slicer is STATE.

    I want to add the count of properties in each STATE on my slicer for my users.  I need guidance on how to do this.


    Example:

    [check box]   AK  4

    [check box]   AL  7

    [check box]   AZ  2

    [check box]   CA  9

     

    Thanks.

steambucky's avatar
steambucky
Helper III
8 years ago

Hello Maggie v-juanli-msft,

 

This is EXACTLY what I am looking for. Thanks SO much.  I still need a hand re-creating your slicer.

 

I have created a calculated column, but regardless of which count type or options on the values i use ( see pics below ) , I can't create a similar Slicer as the one you have made. I can only suspect i am making a simple error somewhere.

 

You you advise with count type and value options ( count distinct? )

 

Thanks so much in advance.

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi steambucky

Sorry for releying late, please look at my file.

calculated column

count of email address = CALCULATE(DISTINCTCOUNT(Sheet2[email address]),ALLEXCEPT(Sheet2,Sheet2[data download]))

select "don't summarize", instead of any aggreation.

 

Best Regards

Maggie

  • steambucky's avatar
    steambucky
    Helper III
    8 years ago

    Thanks so much for your help! :)

  • RA_gov's avatar
    RA_gov
    Frequent Visitor
    7 years ago

    How would I add a count as an additional field in a slicer?

    I have a map report with properties in US states.  My current slicer is STATE.

    I want to add the count of properties in each STATE on my slicer for my users.  I need guidance on how to do this.


    Example:

    [check box]   AK  4

    [check box]   AL  7

    [check box]   AZ  2

    [check box]   CA  9

     

    Thanks.