Forum Discussion

IAMUMER072195's avatar
IAMUMER072195
Frequent Visitor
3 years ago

Performance over period

Hi, I need your help with something if possible. I have a measure in powerbi which looks at the case level to find which employee had performance over 90 between 75 to 90 and less than 75 percent. It is called % Suitability.  Now I am trying to look at the count of employees who had each performance in last month, quearter and year but I am unable to do so, Can you help me with this? Thanks

Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi IAMUMER072195 ,

    In order to give you a suitable solution, could you please provide more raw data in your fact tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    In addition, you can refer the folloiwng links to get it.

    How Many Employees by Period

     

    Total Employees =
VAR LastDateInPeriod =
    MAX ( 'Calendar'[Date] )
VAR FirstDateInPeriod =
    MIN ( 'Calendar'[Date] )
VAR Result =
    CALCULATE (
        COUNTROWS ( Employees ),
        Employees[Commenced] <= LastDateInPeriod, 
        OR ( Employees[Departed] >= FirstDateInPeriod, ISBLANK ( Employees[Departed] ) )
    )
RETURN
    Result

     

    Finding The Percent Of Total In Power BI

    Calculating Percentages

    Best Regards