Forum Discussion
Calculating Rate
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/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
