Please Help: Exclude insignificant values from dataset

Question

&nbsp;Hello I have the following Dataset and I would like to focus only on the items that do have at leat 5 or more entries in my table (my existing filters should apply also)How can I do that?Could it be done also by doing a slicer like the one in the picture where I am only focusing on items with price difference of over 500? so user could change from 5 to another value?PO_lines field is currently the count of every item in my dataset and I do have some filters applied.&nbsp;

pragati11 · Answer

HI&nbsp;varelapablo90&nbsp;,
&nbsp;
Can you share some sample data so that I can create the solution for you? Make sure to remove any sensitive information from the data you share.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
&nbsp;

varelapablo90 · Answer

Please let me know if you are able to get the files, I dont have access to share here.

https://drive.google.com/file/d/1Ln8BqtiMZzVnV9rmt5m77PPzept-b_BV/view?usp=sharing

Thanks a lot for your help 🙂

varelapablo90 · Answer

Still looking for help please.&nbsp;Thanks

v-yanjiang-msft · Answer

Hi&nbsp;varelapablo90&nbsp;,
The compressed package you shared can be downloaded successfully, but it cannot be opened, it seems that the format is incorrect.

In my understanding, you want to use a slicer to filter a measure(if it's a column, you can directly put it in the slicer), I create a sample.

Profit is a measure in the sample.

Here's my solution.
1.Create a parameter.

Set the minimum, maximum and increment value based on your data, here I refer to the min and max of Profit.

2.Create a new measure.
Check = IF('Table'[Profit]&gt;='Parameter'[Parameter Value],1,0)
Put the measure in the visual filter and select its value to 1.

3.Put the parameter in the slicer, the visual will be filtered by changing the value of the parameter.

I attach my sample below for reference.
&nbsp;
Best Regards,Community Support Team _ kalyj
If this post&nbsp;helps,&nbsp;then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;

varelapablo90 · Answer

&nbsp;Hello_ kalyj&nbsp;I have followed your steps and certainly this seems to go in the direction of what need, however It still does not work but now probably due to an issue on the masure.How can I make my measure to work correctly, calculating the count of PO_Lines for each material and considering all the other filters from my page?&nbsp;Check = IF(Merge2_PO_Item[PO_Lines]&gt;='Parameter_PO_Lines'[Parameter_PO_Lines Value],1,0)&nbsp;PO_Lines is my measure, just counting all the records.PO_Lines = count(Merge2_PO_Item[Identification])&nbsp;&nbsp;