Need to convert qlik expression to DAX

[Anonymous]

Hello Team,

I need to convert the qlik Expression to dax.

below is the Qlik Expression 

((AGGR(SUM(Ranking),Company,Month)) /(AGGR(count(MetricName),Company,Month)))*10

I have tried converting into DAX but result is not matching.

((CALCULATE(SUMX(XLI_Metrics,MAX(X_Metrics[Ranking])),FILTER(X_Metrics,XLI_Metrics[Company]=X_Metrics[Company])))/ (CALCULATE(COUNTX(X_Metrics,MAX(X_Metrics[MetricName])),FILTER(X_Metrics,X_Metrics[Company]=X_Metrics[Company])))*10)

[v-yanjiang-msft]

Hi @Anonymous ,

I’m not much clear about your sample, in my understanding, I create a sample, you can see what is different from yours.

Measure =
VAR _SUM =
    SUMX (
        FILTER (
            ALL ( 'X_Metrics' ),
            'X_Metrics'[Company] = MAX ( 'X_Metrics'[Company] )
        ),
        'X_Metrics'[Ranking]
    )
VAR _COUNT =
    COUNTROWS (
        FILTER (
            ALL ( 'X_Metrics' ),
            'X_Metrics'[Company] = MAX ( 'X_Metrics'[Company] )
        )
    )
RETURN
    DIVIDE ( _SUM, _COUNT ) * 10

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

@Anonymous  please provide sample data and desired ouput.

[Anonymous]

Below is the sample data.

MetricName	Ranking
Average initial response	10
Number of cases	10
Time to resolve incident	5
User rating per ticket	10
Time to receive software	10
Time to receive new hardware	1
Total work time for onsite field to resolve	1
Time to receive new hardware	10
Time to create new user account provisioning	5

 Below is the out put.

@smpa01 

[smpa01]

@Anonymous I can't comprehend the requirement from the sample data.