Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 t...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

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

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

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