Slice by "count"

michellepace · October 11, 2020, 3:15pm

Hi there,

I have the following dax measure:
Users = SUM ( Table1[Users])

I need a “Users” slicer where (similar to when slicing with a Date), I can slice for values greater than “n”. When I try to drag my Users measure onto a slicer visual, it simply adds up all my users.

I must be missing something very obvious. Could someone please provide me with some pointers?

Greg · October 11, 2020, 4:42pm

Hi @michellepace.

Do you mean like this?

If so, just drag the [Users] column onto the canvas, make it a slicer, then choose [Greater than or equal to] from the drop-down in the upper-right corner of the slicer.

Hope this helps.
Greg
eDNA Forum - Slice by Count.pbix (17.0 KB)

EnterpriseDNA · October 13, 2020, 12:50am

Thanks for posting your question @michellepace. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

EnterpriseDNA · October 15, 2020, 1:45am

Hi @michellepace, we’ve noticed that no response has been received from you since the 11th of October. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

michellepace · October 16, 2020, 3:35am

Hi Greg,

That is exactly what I need except my Users is a Dax measure… is it possible to filter by a Dax measure?

Greg · October 16, 2020, 10:45am

Hi @michellepace. AFAIK you can’t slice by a measure in Power BI at this time, unfortunately. You can, however, generate your own “lookup” table with your own values of interest by creating a new parameter using the “What If” option built-in to Power BI. For example,

You could then create a measure (say [Total Users]) and use the measure auto-generated by the use of the “What if” parameter dialog like

Total Users = 
CALCULATE( SUM( Users[Users] ),
    FILTER( Users, Users[Users] >= [User Counts Value] ) )

Hope this helps.
Greg
eDNA Forum - Slice by Count v2.pbix (18.9 KB)

michellepace · October 25, 2020, 5:02am

Thanks very much Greg, I would have never thought of this!