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

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.

Reply
Dallas7890
Helper I
Helper 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
Super User
Super User

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
Super User
Super User

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors