Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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!
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 7 | |
| 6 | |
| 5 | |
| 5 |
| User | Count |
|---|---|
| 24 | |
| 11 | |
| 9 | |
| 9 | |
| 8 |