Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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
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
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 27 | |
| 23 | |
| 18 | |
| 18 | |
| 15 |
| User | Count |
|---|---|
| 53 | |
| 44 | |
| 42 | |
| 39 | |
| 34 |