A measure to find the # of Models Sold more than 25

[YavuzDuran]

HI,

I need a measure to find the # of vehicle models which sold more than 25 on a selected Calendar year. 

ie. There are 19 models which sold more than 25 in the list below. 

and is there any way to put this limit # 25 in a slicer so I can change it easily instead of hardcoding into the formula? 

ie. Finding the vehicles sold more than 10

[Anonymous]

Hi @YavuzDuran ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Shishir22]

Hello @YavuzDuran ,

Try this - 
1. Create a parameter as whole number from 0 to 500(or possible max value) with increment of 1.

2. Create a measure as:

Flag = 
VAR _sold= SUM(Data[# of Sold])
Var _parameter = SELECTEDVALUE(Parameter[Parameter])
VAR _result = IF(_sold>_parameter,1,BLANK())
Return
_result

This Measure will return flag as 1 or blank.

Use this measure as visual level filter and set equals to 1.

Please mark this post as solution if it fulfils your requirement. Kudos are also accepted.

Cheers!

[parry2k]

@YavuzDuran I don't what measure you are using, you need to copy the measure from my file, not sure what else to tell? Did you copy the measure from my file? Not sure what have you tried from my solution? You have to be more clear what you have tried

[parry2k]

@YavuzDuran see attached solution,

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[YavuzDuran]

Am I missing something? Table is not filtering as I a forwarding the slicer @parry2k 

[PaulDBrown]

You can't type in parameters once the report is published, but you can create a table with values to use as a slicer.

Create a table with the threshold values for sales. This is my example. I created the list in Excel and simply pasted it into a table using the "Enter data" in the ribbon). You can also create the list directly in Desktop using "New Parameter" under modeling in the ribbon.

 Leave this table unrelated in the model.

Now create the following measures:

Sum Sold = SUM(FactTable[# Sold])

Threshold filter =
COUNTROWS (
    FILTER (
        FactTable,
        [Sum Sold] > SELECTEDVALUE ( 'Sales Threshold'[Sales Threshold] )
    )
)

Add this [Threshold filter] measure to the filters on the visual in the filter pane and set the value to 1.

Add a slicer from the Threshold Sales table and you get:

[YavuzDuran]

Model	# of Sold
C-Class	215
Malibu	202
E-Class	185
Impala	150
CLA-Class	145
Altima	140
Sonata	132
Optima	112
Camry	100
Equinox	95
Charger	62
Passat	60
Rogue	50
GLA-Class	40
Accord	38
3-Series	36
ES 350	35
Jetta	34
Elantra	26
S-Class	24
Fusion	22
5-Series	20
Fusion Hybrid	18
Sentra	12
Tiguan	10
4-Series Gran Coupe	9
Outlander	8
X5	8
Challenger	6
X1	6
XTS	5
Corolla	4
Forte	3
RX 350	3
F-150	3
Camaro	2
Civic	2
GLC-Class	2
Silverado 1500	2