Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
CS-TY26
New Member

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 2
lbendlin
Super User
Super User

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-...
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/1447523

I 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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors