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.

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

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.