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 if the reply is helpful--
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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 if the reply is helpful--