I have Created a measure Calc_QPPM. Now I want to create another measure using Calc_QPPM

[seenai]

Hi,

I have Created a measure Calc_QPPM.

Now I want to create another measure using Calc_QPPM, as below.

Score_QPPM =

if([Calc_QPPM]<=10000,25,

if([Calc_QPPM]<=50000,22,

if([Calc_QPPM]<=1000000,20,15)))

Its not showing properly.

Request your help.

Note : 

Calc_QPPM = (sum(T_MW_VR02[N.of Scraps (D)])+sum(T_MW_VR02[N.of Deviations (E)]))/sum(T_MW_VR02[Received Qty (F)])*1000000

[amitchandak]

Hop KPI QPPM is same as Score_QPPM.

Share calculation of Calc_QPPM

[seenai]

Hi, @amitchandak 

a) Yes. KPI QPPM is same as Score_QPPM.

KPI QPPM : Excel Value

Score_QPPM : Power BI Calculation. It is needed for consolidation purpose. 

b) Formula for Calc_QPPM is as below :

Calc_QPPM = (sum(T_MW_VR02[N.of Scraps (D)])+sum(T_MW_VR02[N.of Deviations (E)]))/sum(T_MW_VR02[Received Qty (F)])*1000000

[amitchandak · Accepted solution]

@seenai Try like this

maxx(summarize(T_MW_VR02, Month[Month Name], vendor[ID],, vendor[name],"_Mes",[Score_QPPM ]),[_Mes])

[seenai]

Hi

@amitchandak / @v-lionel-msft 

I have reverified my measures and data.

There is Month_Year Table (Calender), for use as common filter between databases.

The relationship is as shown below.

The measure is working OK, if don't apply any filter.

It is not Ok, only if I put Year Filter. Help me, if any.

[v-lionel-msft]

Hi @seenai ,

I tested your formula, no problem, I do n’t know how you display your measure, you cannot display the measure alone, you need to display it with other columns, otherwise the result returned by the measure is aggregated.

Calc_QPPM = ( SUM('Sales 2015'[Sale 2013])+SUM('Sales 2015'[Sale 2014]) ) /SUM('Sales 2015'[Sale 2015])*1000000

Score_QPPM = 
IF(
    [Calc_QPPM] <= 50000000,
    25,
    IF(
        [Calc_QPPM] <= 50000,
        22,
        IF(
            [Calc_QPPM] <= 1000000,
            20,
            15
        )
    )
)

If the problem is not resolved, please describe how you intend to display the measure.

Best regards,
Lionel Chen

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