Filter a measure base on slicer

[lliu08]

Hello Community, 

I have a measure that calculates the cumulative revenue of a project. 

Cumulative Project Revenue =

CALCULATE(

SUM(Project_Profit[Revenue]), FILTER(ALL(Project_Profit),

Project_Profit[Accounting_Date] <= MAX ('Date Table'[Date])

),GROUPBY(ProjectList,ProjectListr[ProjectDescription])

)

I need a slicer bar and when I drag the bar from, let's say minimum project revenue of $30,000 - so in this case, I drag the bar to a minimum $30,000

then I want the table that shows  originally

ProjectDescription	Cumulative Revenue
A	$45,000
B	$20,000
C	$30,000
D	$12,000

to 

ProjectDescription	Cumulative Revenue
A	$45,000
C	$30,000

when the slicer is being dragged to $30,000.

Please let me know if this is possible, thank you. 

[Anonymous]

• I have a calculated measure which consists percentage value. I just want to use the percentage range for the visualization. How can I make it using switch case statement.

[amitchandak · Accepted solution]

@lliu08 , You can have what if parameter and use its min and max value as an additional filter in formula

https://docs.microsoft.com/en-us/power-bi/desktop-what-if