Hi! I am just starting out with PowerBI and this will be be first real dashboard. I am trying to create a dashboard that calculates the usage rate of other dashboards so the table would look like this :
| ToolName | UserName | UserEmail | UseDate |
A | user1 | n | 7/1/2025 |
| A | user3 | n | 7/2/2025 |
| B | user2 | n | 7/1/2025 |
| C | user3 | n | 7/1/2025 |
| B | user1 | n | 7/2/2025 |
| A | user2 | n | 7/3/2025 |
| C | user3 | n | 7/4/2025 |
| C | user2 | n | 7/4/2025 |
| B | user2 | n | 7/1/2025 |
And I would like to calculate usage rate with the formula = (days the app was used/total number of days in a quarter)*100.
Usage Rate for Tool A = 3/63
Usage Rate for B = 2/63
Usage Rate for C = 2/63
The current formula I have is throwing a syntax error :
var ANumerator = CALCULATE(DISTINCTCOUNT('Usage Rate'[UseDate]),FILTER('Usage Rate','Usage Rate'[ToolName] = "A"))
