Multiple Incident employee count based on selected date range.

[VenkateshLanka]

Hello,

I am looking for multiple incident employee count based on selected date range.
Deacription : - If any employee involved more then once incident in year need show, please see the below screenshot for more datails.
Location information form location table employee info from MIE table (relation many to one cross filter both dirction ) please help thank you.

[v-yanjiang-msft · Accepted solution]

Hi @VenkateshLanka ,

According to your description, here's my solution.

Sample:

Create a measure:

Measure =
VAR _count =
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Incident Category] ),
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF ( _count > 1, MAX ( 'Table'[Incident Category] ), BLANK () )

Get the correct result:

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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

[foodd]

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.