topic Re: Measure to count the number of Opps that contain a certain product in DAX Commands and Tips

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

Anonymous — Mon, 09 Aug 2021 14:42:52 GMT

This post has now been deleted.

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

Fowmy — Thu, 14 Jan 2021 12:37:22 GMT

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

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

Anonymous — Mon, 09 Aug 2021 14:43:31 GMT

This post has now been deleted.

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

Fowmy — Thu, 14 Jan 2021 13:44:02 GMT

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