Problems with DAX measure : Calculate filters and TOPN

[Anonymous]

Hello, 

I am trying to filter the gross contracts by all these filters  and the only thing that I am missing is that after all this filters applied I need just the top 10 of them. I need this as a dax measure so I can divide it by other measure after.

Measure Total Gross Contract = CALCULATE(SUMX('ACQ BI','ACQ BI'[Gross Contract]),'ACQ BI'[CONTRACT.REC.1]=1,'CONTRACTS BI'[NUM.OF.ASSETS]>0,'CONTRACTS BI'[UATB.ANNUAL.BLENDED.YIELD.DAT]>0,'ASSETS BI'[UATB.PROGRAM.TYPE]<>6,'ACQ BI'[PROGRAM.TYPE]<>10)

Thanks for your help

[Anonymous]

Hi @Anonymous,

Please share some sample data so that we can coding formula and testing on it.

Regards,

Xiaoxin Sheng

[jdbuchanan71]

Give this a try.

Total Gross Contract Top 10 =
CALCULATE (
    [Total Gross Contract],
    TOPN ( 10, 'ACQ BI', [Total Gross Contract], DESC )
)