cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

## distinct count of occurence by category

Hi!

I have table with

Product and Value fields

I need to count nr of products which have more then 9 occurences of Values.

I tried this measure, but I guess its different contex.

CALCULATE(DISTINCTCOUNT(Table[Product]), FILTER(Table, DISTINCTCOUNT(Value) > 9))

2 ACCEPTED SOLUTIONS
Super User

try like:

Measure =
VAR _table =
VALUES(TableName[Product]),
"Count",
CALCULATE(COUNTROWS(TableName))
)
RETURN
COUNTROWS(
FILTER(
_table,
[Count]>9
)
)
Community Support

Hi, @DagmaraG

You can try the following methods.

Measure:

``Count1 = COUNT('Table'[Product])``
``Count2 = CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER(ALL('Table'),[Count1]>=9))``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

2 REPLIES 2
Community Support

Hi, @DagmaraG

You can try the following methods.

Measure:

``Count1 = COUNT('Table'[Product])``
``Count2 = CALCULATE(DISTINCTCOUNT('Table'[Product]),FILTER(ALL('Table'),[Count1]>=9))``

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

Super User

try like:

Measure =
VAR _table =
VALUES(TableName[Product]),
"Count",
CALCULATE(COUNTROWS(TableName))
)
RETURN
COUNTROWS(
FILTER(
_table,
[Count]>9
)
)

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors