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.
I need to calculate average reliability for each site which will be sum of (Reliability Old M)for all assets in a site(NDA and 3 other sites) divided by count of assets in a site. (Reliability Old M) is a measure and not column
below measure is not working
Reliability= DIVIDE(SUMX('MeterReading','MeterReading'[Reliability Old M]),'MeterReading'[COUNT(Assets by site M)])
Solved! Go to Solution.
Please try
Reliability =
AVERAGEX (
SUMMARIZE ( 'MeterReading', 'MeterReading'[Site], 'MeterReading'[Asset] ),
[Reliability Old M]
)
Ok let's try
Reliability =
AVERAGEX (
CROSSJOIN ( VALUES ( 'MeterReading'[Site] ), VALUES ( 'MeterReading'[Asset] ) ),
COALESCE ( [Reliability Old M], 0 )
)
Hi @WTAS80486
it depends where do you want to view this measure. Uou can use the following if you are slicing by Site.
Reliability =
AVERAGEX ( VALUES ( 'MeterReading'[Site] ), [Reliability Old M] )
you can also edit the original measure in order to see the old value at the asset level and the average at the site level in the same matrix
This is not working
It needs to be here for site, so summ of all reliability Old M / No of assets in this site
Please try
Reliability =
AVERAGEX (
SUMMARIZE ( 'MeterReading', 'MeterReading'[Site], 'MeterReading'[Asset] ),
[Reliability Old M]
)
In the below expression
Reliability =
AVERAGEX (
SUMMARIZE ( 'MeterReading', 'MeterReading'[Site], 'MeterReading'[Asset] ),
[Reliability Old M]
It is calculating average at the site level but considering only those assets which have reliability value populated at asset level, whereas i wanted to include all assets in count(even the ones with blank reliability values)
Hi @WTAS80486
please try
Reliability =
AVERAGEX (
CROSSJOIN ( VALUES ( 'MeterReading'[Site] ), VALUES ( 'MeterReading'[Asset] ) ),
[Reliability Old M]
)
Gives the same thing
It is not taking all assets in account( excluding the ones with blank [Reliability Old M] value
Ok let's try
Reliability =
AVERAGEX (
CROSSJOIN ( VALUES ( 'MeterReading'[Site] ), VALUES ( 'MeterReading'[Asset] ) ),
COALESCE ( [Reliability Old M], 0 )
)
In the expression
Ok let me reframe
I want to calculate MTBF at asset level= Rolling runhours/rolling failures
Condition is that if either of rolling runhours or rolling failures is 0 then MTBF should be blank, which is not happening now
Then at site level (space in red) i want to also calculate MTBF average=total MTBF by count of non blanks MTBF and not by count of asset in that site
It is difficult to answer your question without having my eyes on the data and the data model. It would be really helpful if you can share a sample file that contains a reasonable amount of dummy data that simulates the actual data.
So this expression
But as you can see MTBF(M) is 0.00 when rolling runhours is 0.00
and blank when failures 0
Desired result is --> if either of rolling runhours or rolling failures is 0 then MTBF(M) should be blank
Also after this calculation which is for each asset under site, an average at site level should be calculated for space in red which will be = sum of MTBF(M)/COUNT of Non blanks MTBF(M) under that site (Ex MOU)
Now another measure
So i got blank result if either rolling runhours or rolling failures is 0
@tamerj1I am calculating average Mean at the site level for all assets under that site
This dashed line is average line in colum chart
But i wanted to used line and column chart and use the average expression in Line y-axis
Could you please help!
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
50 | |
46 | |
16 | |
12 |