PowerBi Count with Multiple criteria

Kimberly Jamieson 1 Reputation point
2022-02-03T20:33:18.58+00:00

I have a dataset that I am trying to calculate ratios for. I am successful with a some but am getting hung up on 1 in particular, Employee/(GF+Supervisor) So the Count of employees divided by the combined count of General Foreman and Supervisors.
My dataset has a column for Job Type (which is either Employee, General Foreman, Supervisor, or Other.
It seem so simple yet I’m struggling with it.

Employee/GF+Supervisor = DIVIDE(
CALCULATE(COUNT('Data for PowerBi'[Job Type]),'Data for PowerBi'[Job Type] = "Employee"),
CALCULATE(COUNT('Data for PowerBi'[Job Type]),'Data for PowerBi'[Job Type] = "Supervisor"),('Data for PowerBi'[Job Type]),'Data for PowerBi'[Job Type] = "General Foreman"))

As an example, this function is successfully working:
Employee/GF = DIVIDE(
CALCULATE(COUNT('Data for PowerBi'[Job Type]),'Data for PowerBi'[Job Type] = "Employee"),
CALCULATE(COUNT('Data for PowerBi'[Job Type]),'Data for PowerBi'[Job Type] = "General Foreman"))

THANK YOU

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,086 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2022-02-03T20:34:49.483+00:00

    Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
    https://community.powerbi.com/

    --please don't forget to upvote and 145510-image.png if the reply is helpful--

    0 comments