topic How to use the DAX variable s in the measure below in another measure? in DAX Commands and Tips

How to use the DAX variable s in the measure below in another measure?

vedhikha — Fri, 31 Mar 2023 19:32:22 GMT

The below DAX returns both "ontime " and "delayed" when pulled into a donut chart. I want to write a DAX that only pulls the "ontime" in the donut chart.

Status measure =

VAR s = CALCULATE(COUNTX(FILTER(SUMMARIZE(OnTimePerformance,OnTimePerformance[carr_desc],OnTimePerformance[LD_LEG_ID],OnTimePerformance[actual_departure_deviation],OnTimePerformance[SRA_NUMBER],OnTimePerformance[APPOINTMENT DELIVERY WINDOW],OnTimePerformance[actual_dlvy],OnTimePerformance[LANE],"Status",[Dly_Variance]),[Status]="Ontime"),[Status]), USERELATIONSHIP(CalendarTable[Datekey],OnTimePerformance[actual_dlvy_key]), USERELATIONSHIP(Carrier[SCAC],OnTimePerformance[CARR_CD]))

VAR s1 = CALCULATE(COUNTX(FILTER(SUMMARIZE(OnTimePerformance,OnTimePerformance[carr_desc],OnTimePerformance[LD_LEG_ID],OnTimePerformance[actual_departure_deviation],OnTimePerformance[SRA_NUMBER],OnTimePerformance[APPOINTMENT DELIVERY WINDOW],OnTimePerformance[actual_dlvy],OnTimePerformance[LANE],"Status",[Dly_Variance]),[Status]="Delayed"),[Status]), USERELATIONSHIP(CalendarTable[Datekey],OnTimePerformance[actual_dlvy_key]),USERELATIONSHIP(Carrier[SCAC],OnTimePerformance[CARR_CD]))

Return SWITCH(SELECTEDVALUE('Status'[Status]),"Ontime",s,s1)

Re: How to use the DAX variable s in the measure below in another measure?

olgad — Sat, 01 Apr 2023 14:28:49 GMT

Hi,

do you want to show only ontime-77.52?

Calculate(DIVIDE(MAXX(ALLSELECTED(Table[Status]),[YOUR MEASURE]), CALCULATE([YOUR MEASURE],ALL(Table[Status]))

), Table[Status]="Ontime")
example how it will look like

Re: How to use the DAX variable s in the measure below in another measure?

vedhikha — Mon, 03 Apr 2023 12:00:18 GMT

olgad Yes. I want just 77.52.

Measure 3 = Calculate(DIVIDE(MAXX(ALLSELECTED('Status'[Status]),'Status'[Status measure]), CALCULATE('Status'[Status measure],ALL('Status'[Status]))), 'Status'[Status]="Ontime")

When I do this, I get 3.45.

Re: How to use the DAX variable s in the measure below in another measure?

vedhikha — Mon, 03 Apr 2023 12:15:30 GMT

Re: How to use the DAX variable s in the measure below in another measure?

olgad — Mon, 03 Apr 2023 15:07:02 GMT

Dont place it on the pie chart, it doesnt male sense to use a pie chart showing only one ontime. Make a card with the % theb the value shall be correct. Or how do you imagine it to look?

Re: How to use the DAX variable s in the measure below in another measure?

vedhikha — Mon, 03 Apr 2023 16:53:58 GMT

olgad : I used the measure and placed it as a card within my donut chart. Thank you so much, this just gives me the Ontime %