Table or multi-card with list of values

[Anonymous]

Hi, 

I have a table with a list of customers; I also have a numeric range parameter. I want to show in a table or a multi-card all the customers with >= number of orders than the value in the parameter slicer. Is there a way?

Thank you!!

[v-cazheng-msft · Accepted solution]

Hi @Anonymous,

You may try this solution.

Here is the sample data used.

Orders table

Numeric Range table

Then, you need a measure.

FilterCx =
VAR selectedNumeric =
    SELECTEDVALUE ( 'Numeric Range'[numeric range parameter] )
VAR count_order =
    CALCULATE ( COUNT ( Orders[orderDate] ), VALUES ( Orders[customer] ) )
RETURN
    IF ( count_order >= selectedNumeric, 1, 0 )

After that, you need filter your table built with customers info with visual level filter.

The result will look like this.

Also, attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[amitchandak]

@Anonymous , Assume you have measure

Order count = count(Table[Order No])

or

Order count = countrows(Summarize(Table,Table[Order No]))

this joined with Customer dimension

Countx(Values(Customer[Customer]), if([Order count] >= [What if Parameter measure], [Customer], Blank() ))

You can sue what if parameter to select the parameter you wanted- https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if