cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vengadeshpalani
Helper III
Helper III

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

 

Screenshot_5.png

 

 

1 ACCEPTED SOLUTION
mwegener
Super User II
Super User II

Hi @vengadeshpalani 

 

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

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


View solution in original post

1 REPLY 1
mwegener
Super User II
Super User II

Hi @vengadeshpalani 

 

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

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website


View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors