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.
Hello,
I am trying to figure out why this is happening. The numbers are all repeating.
Example for January
The only Network feed that should show this amount for availability issues is "Listen" but all the other 8 Network feeds should show 100% availability for running a perfect time of 24 hours per day which is, 691200 per second. Plus, only four Networks are showing, and it should be all eight network names from the table below.
Here is a snapshot of what I am seeing in my PBI report
These are the measures I wrote
This is the Excel spreadsheet and the same amounts that I am aiming for in PBI using the measures.
Daily perfect duration (secs) = SUM(Prime [Tot Hrs x Networks])*60*60 | 691200 | ||||||||||||||||||||||||||
Monthly perfect duration (secs) 28 days = DaysPerMonth x Daily Prime perfect duration (secs) | 19353600 | ||||||||||||||||||||||||||
Monthly perfect duration (secs) 30 days = DaysPerMonth x Daily Prime perfect duration (secs) | 20736000 | ||||||||||||||||||||||||||
Monthly perfect duration (secs) 31 days = DaysPerMonth x Daily Prime perfect duration (secs) | 21427200 | ||||||||||||||||||||||||||
Test | |||||||||||||||||||||||||||
January 2023 | Monthly error duration (secs) | 1800.00 | |||||||||||||||||||||||||
Monthly uptime (secs) = Monthly perfect duration (secs) - Monthly error duration (secs) | 21425400.00 | ||||||||||||||||||||||||||
Monthly Availability (%) = Monthly uptime (secs) / Monthly perfect duration (secs) x 100 | 99.99159946 | ||||||||||||||||||||||||||
All at 100% except Listen | 99.99159946 | ||||||||||||||||||||||||||
Solved! Go to Solution.
Can you share please your PBI with example data.
Proud to be a Super User!
Can you share please your PBI with example data.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |