Forum Discussion
Measure value filter by using parameter selection
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 ) )
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])
1 Reply
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])