Help in filtering data

Hi,

Create a calculated column to count the number of distinct products each customer has used:

ProductCount = CALCULATE( DISTINCTCOUNT(CustomerData[ID_product]), ALLEXCEPT(CustomerData, CustomerData[CustomerID]) )

Create another calculated column to count the total number of usages for each customer:

UsageCount =
CALCULATE(
COUNT(CustomerData[UsageDate]),
ALLEXCEPT(CustomerData, CustomerData[CustomerID])
)

Create a calculated column to identify customers who meet both criteria (using at least 2 different products and having at least 5 usages):

IsQualified =
IF(
[ProductCount] >= 2 && [UsageCount] >= 5,
1,
0
)

You can now use this IsQualified column to filter your visuals. For example, if you are creating a table or chart, you can add a visual-level filter to only include rows where IsQualified is 1.