How to calculate the new measure from another measure based on hour as category or group?

[Madhan_]

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 

Total Mission by Time = CALCULATE(count(space_missions[Mission]),ALLEXCEPT(space_missions,space_missions[Hour]))

and to filter only successful missions from the table  i created a measure

Successful Missions = CALCULATE([Total Missions],space_missions[MissionStatus]="Success")

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

[v-yinliw-msft · Accepted 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.

[amitchandak]

@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