Measure value filter by using parameter selection

Anonymous — Fri, 29 May 2020 07:43:42 GMT

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 ) )

Re: Measure value filter by using parameter selection

mwegener — Fri, 29 May 2020 21:01:33 GMT

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])

topic Measure value filter by using parameter selection in Desktop

Measure value filter by using parameter selection

Re: Measure value filter by using parameter selection