Skip to main content
cancel
Showing results for
Search instead for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## count numbers in calculated row

Hi,

I have a table of Presence of certain employees at certain events.

for each event it will list the eventnumber and employee name in a row.

Richt now in the report i just count the occurences and it tells me for each employee how many events they attende within a filtered period of time.

 Event Employee 1 a 1 b 2 a 2 b 3 b

The problem occurs when i try to list how may employees have attended how many events.

e.g.

 # of events # of employees 3 1 2 1 1 0

We need this data because they are required to attend certain amount of events in a given period. this will help us track how many have not completed it.

Optimaly i find a sollution that still allows me to filter based on Time periods.

I have been looking at measures but I can't manage to get the correct output.

Thanks in advance.

1 ACCEPTED SOLUTION
Super User

@tproost, I think you Dynamic segmentation, refer example

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

3 REPLIES 3
Super User

Hi,

The numbers shown in the result table seems wrong.  the number of people who attended 3 events should be 0.  Please show the expected result very clearly.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
Community Support

Hi  @tproost ,

I created some data:

Here are the steps you can follow：

Way1
Set [Employee] to Count (Distinct)

Ways2：

Create measure.

``````Measure =
var _mindate=MINX(ALLSELECTED('Table'),[Date])
var _maxdate=MAXX(ALLSELECTED('Table'),[Date])
return
CALCULATE(
DISTINCTCOUNT('Table'[Employee]),
FILTER(ALL('Table'),'Table'[Event]=MAX('Table'[Event])))``````

Result:

Best Regards,

Liu Yang

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

Super User

@tproost, I think you Dynamic segmentation, refer example

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors