Forum Discussion
Calculating Rate
Hello!
First time poster here and fairly new to Power Bi.
I am working on creating a rate per 1000 days calcualtion. I have a category of infection and I am wanting to pull in a sub category, lets say "Bacterial" for this example.
I want to take that sub category, divide it by a count of days that a doctor would see patients (called residents x days- Q1 being 13064) then convert it into a rate per 1000 days.
Any idea how to do so with this information or do I need to provide more?
Thank you in advance!
Ty
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523I can get you a better snapshot of the data if you need. I have been doing some research online and I have created this formula but it is not displaying any values when I try to put it into a number card for presentation.
Bacterial Count Q1 =
DIVIDE(
CALCULATE(
COUNT('Infection Control Log'[Category of Infection]),
'Infection Control Log'[Category of Infection] = "Bacterial",
'Infection Control Log'[Fiscal Quarter] = "Q1",
'Infection Control Log'[Fiscal Year] = SELECTEDVALUE('Infection Control Log'[Fiscal Year])
),
13064
) * 1000
