Measure to calculate percentage of closed date IncidentID Ticket

[Zaky]

Hi,

Could someone please help me on this. I want to get a gauge percentage of MeasurementStatus=’Met’ for which Closed Date=Num of MonthStart of current month. Sorry, maybe my explanation above couldn’t be understandable. But recently I’ve successful used the following measure in QlikSense: 

=count({<MeasurementStatus={'Met'},[Closed Date]={">=$(=Num(MonthStart(Max([Closed Date]))))<=$(=Max([Closed Date]))"}>} [Incident ID])/count({<[Closed Date]={">=$(=Num(MonthStart(Max([Closed Date]))))<=$(=Max([Closed Date]))"}>} [Incident ID])

Thanks.

[v-frfei-msft]

Hi @Zaky,

Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

Regards,

Frank

[Zaky]

Hi,

You may download the file here

Excepted result is that the gauge will get a percentage for the current month of Closed Date by count table MeasurementStatus='Met'

[v-frfei-msft · Accepted solution]

Hi @Zaky,

To create a measure as below.

Measure 2 = 
CALCULATE (
    COUNTROWS ( 'Incident Raw Data (SLA Response' ),
    FILTER (
        'Incident Raw Data (SLA Response',
        'Incident Raw Data (SLA Response'[MeasurementStatus] = "Met"
    )
)
    / COUNTROWS ( 'Incident Raw Data (SLA Response' )

For more details, please check the pbix as attached.

Regards,

Frank

[Zaky]

Hi,

Thanks dude. It's work as what i required.

Awesome!

Regards

Zaky