The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I want to create a success rate of mission by time. The formula is = successful missions by time / total mission by time. For that I have already created a measure for the total mission by time
From this, I want to calculate successful missions by time. For that, i don't know how to calculate a new measure called successful missions by time from the calculated measure of Successful missions based on hours as a group. Could you please help to resolve
Solved! Go to Solution.
Hi @Madhan_ ,
I use this as a sample data:
You can try this method:
Create two measures:
SuccessMission =
CALCULATE (
COUNTROWS ( 'space_missions' ),
FILTER (
'space_missions',
AND ( 'space_missions'[MissionStatus] = "Success", 'space_missions'[Hour] )
)
)
SuccessfulRate =
DIVIDE (
'space_missions'[SuccessMission],
'space_missions'[Total Mission by Time]
)
The result is:
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Madhan_ ,
I use this as a sample data:
You can try this method:
Create two measures:
SuccessMission =
CALCULATE (
COUNTROWS ( 'space_missions' ),
FILTER (
'space_missions',
AND ( 'space_missions'[MissionStatus] = "Success", 'space_missions'[Hour] )
)
)
SuccessfulRate =
DIVIDE (
'space_missions'[SuccessMission],
'space_missions'[Total Mission by Time]
)
The result is:
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Madhan_ , You can use date table and time intelligence
MTD Successful Missions= CALCULATE([Successful Missions],DATESMTD('Date'[Date]))
last MTD Successful Missions= CALCULATE([Successful Missions],DATESMTD(dateadd('Date'[Date],-1,MONTH)))
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |