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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.