Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good day,
I have two tables, related to each other by fist column (name of the source file). I'm looking for measure to show me how many "RISK and HIGH RISK" checks were done comparing to "none or standard". Result should be in procents and filtered by year (2021)
SOURSE FILE NAME | REASON FOR CHECK | SOURSE FILE NAME | Date of Check | ||
1 | none | 1 | 2020 | ||
2 | risk | 2 | 2020 | ||
3 | high risk | 3 | 2021 | ||
4 | none | 4 | 2021 | ||
5 | standard | 5 | 2021 | ||
6 | risk | 6 | 2021 |
For example in 2021 there were 4 checks where two of these were (Risk/High Risk) - final result is 50% in 2021.
Thnaks
Aleks
Try these measures:
Check Count = COUNT ( CheckReason[SOURSE FILE NAME] )
Check Percent =
VAR vNumerator =
CALCULATE (
[Check Count],
CheckReason[REASON FOR CHECK] IN { "risk", "high risk" }
)
VAR vDenominator = [Check Count]
VAR vResult =
DIVIDE ( vNumerator, vDenominator )
RETURN
vResult
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |