Measure to count the number of Opps that contain a certain product

[Anonymous]

This post has now been deleted. 

[Fowmy]

@Anonymous 

Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

This post has now been deleted.

[Fowmy]

@Anonymous 

Create one of the following measure. I filter the Sales Stage, I get one as the result:

Count Measure = 

VAR __Table = { "Dragon Fruit", "Lychee", "Passion Fruit" }
VAR __Table2 =
    ADDCOLUMNS (
        FILTER( table8, Table8[Sales Stage] = "06 - Won, Deploy & Expand"),
        "Exists", INT ( Table8[Product Category - Custom Group] IN __Table )
    )
RETURN
    COUNTROWS (
        FILTER (
            GROUPBY (
                __Table2,
                Table8[Opportunity ID],
                "Count", SUMX ( CURRENTGROUP (), [Exists] )
            ),
            [Count] > 1
        )
    )

To get the 2 as the result, remove filter on Sales Stage:

Count Measure = 

VAR __Table = { "Dragon Fruit", "Lychee", "Passion Fruit" }
VAR __Table2 =
    ADDCOLUMNS (
        // FILTER( table8, Table8[Sales Stage] = "06 - Won, Deploy & Expand"),
        Table8,
        "Exists", INT ( Table8[Product Category - Custom Group] IN __Table )
    )
RETURN
    COUNTROWS (
        FILTER (
            GROUPBY (
                __Table2,
                Table8[Opportunity ID],
                "Count", SUMX ( CURRENTGROUP (), [Exists] )
            ),
            [Count] > 1
        )
    )

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn