Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Dallas7890
Resolver I
Resolver I

DAX Measure not working properly

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 

Dallas7890_0-1678108552367.png

 

These are the measures I wrote

Dallas7890_1-1678108611812.png

 

Dallas7890_2-1678108651849.png


Dallas7890_4-1678108713562.png

 

Dallas7890_5-1678108748321.png

 

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                       
                            

 

1 ACCEPTED SOLUTION
andhiii079845
Solution Sage
Solution Sage

Can you share please your PBI with example data. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
andhiii079845
Solution Sage
Solution Sage

Can you share please your PBI with example data. 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.