cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jsuttmann
Helper I
Helper I

Slicer Based on Count

I need help building a slicer that is based on a count of transactions per user.  My dataset has a column of users and a column of transaction IDs.  I have a visual showing all the distinct users in my dataset and a count of transaction IDs associated to each user.  I want to build a slicer that allows me to define a minimum count of transaction IDs to display in the visual.  For example, if my slicer is set to a minimum count of 3 transaction ID, my visual would exclude users with counts of 1 or 2 transaction IDs.  

1 ACCEPTED SOLUTION
jgeddes
Solution Sage
Solution Sage

You could accomplish this with a parameter.

For example if I want to limit the count of services from my table

jgeddes_0-1664559344428.png

I can create a parameter named "Minimum TXs" and then write my measure as follows

Count of Services =
var _serviceCount =
COUNT(clientTable[ServiceName])
var _minTXs =
'Minimum TXs'[Minimum TXs Value]
var _table =
FILTER(clientTable, clientTable[ServiceName])
Return
IF(
    _serviceCount >= 'Minimum TXs'[Minimum TXs Value],
    SUMX(FILTER(SUMMARIZE(clientTable, clientTable[Client_Name], "_count", COUNT(clientTable[ServiceName])), [_count] > 'Minimum TXs'[Minimum TXs Value]),[_count]),
    BLANK()
)

I would then end up with 

jgeddes_2-1664559447810.png 

jgeddes_0-1664560584012.png

Hope this points you in the right direction.

 

View solution in original post

1 REPLY 1
jgeddes
Solution Sage
Solution Sage

You could accomplish this with a parameter.

For example if I want to limit the count of services from my table

jgeddes_0-1664559344428.png

I can create a parameter named "Minimum TXs" and then write my measure as follows

Count of Services =
var _serviceCount =
COUNT(clientTable[ServiceName])
var _minTXs =
'Minimum TXs'[Minimum TXs Value]
var _table =
FILTER(clientTable, clientTable[ServiceName])
Return
IF(
    _serviceCount >= 'Minimum TXs'[Minimum TXs Value],
    SUMX(FILTER(SUMMARIZE(clientTable, clientTable[Client_Name], "_count", COUNT(clientTable[ServiceName])), [_count] > 'Minimum TXs'[Minimum TXs Value]),[_count]),
    BLANK()
)

I would then end up with 

jgeddes_2-1664559447810.png 

jgeddes_0-1664560584012.png

Hope this points you in the right direction.

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.