Measure value filter by using parameter selection

[Anonymous]

hi all,

i want to filter measure value by using parameter selection

i'm using following measure value. its working fine in table. but it's not shown total value in KPI card.

how can i show total vale in KPI Card?

i have attached Test file Pbix File 

Sales by filter = 
VAR m = max('Table (2)'[Sales Bucket Value])
RETURN
CALCULATE ( SUM ( 'Table'[sales] ), FILTER ( 'Table', sum('Table'[sales]) <= m ) )

[mwegener · Accepted solution]

Hi @Anonymous 

try this.

Sales by filter = 
VAR m = max('Table (2)'[Sales Bucket Value])
RETURN
SUMX(FILTER(SUMMARIZE('Table','Table'[Customer],"Sum Sales",SUM('Table'[sales])),[Sum Sales] <= m), [Sum Sales])