Summarize data and connect with a slicer

[wiredguy77]

I have a table(sales), which has a product name and date it was purchased. I have connected this table(sales) to a calendar slicer.

So when the date changes, the data also changes. What I am interested in here is to display the products that were present during the time range for more than 30% of the time. 

I tried with a summarize and filter but I am not able to do it.

Any help will be appreciated.

[v-xinruzhu-msft]

Hi @wiredguy77 

You can consider to create a measure to juge if the record is over 30% , if it is meet the condition, then return 1 else return 0, then put the meaure to the visual filter, set the condition that when the measure is equak to 1, then display. 

If the information above cannot meet your requirements, can you provide some sample data or smaple pbix file?

Best Regards!

Yolo Zhu

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