Dynamic Percentage of two summed columns with between dates

[ale_spruce34]

Hello All,

I need help in creating a measure that will calculate the percentage of two columns that dynamically changes with date slicer (between dates). 

My table looks like below: 

Part	RMAs	Sold	% of Model Sales
1	2065	91358	0.17
2	457	2903	0.04
3	365	14038	0.03

My current measure is: 

Percent = (DIVIDE(SUM('table1'[RMAs]),CALCULATE(SUM('table1'[Sold]))))

However it is giving me the incorrect %, the first row should be (2065/91358 = 0.22%), any suggestions here?

[amitchandak]

@ale_spruce34 , Not very clear, do you need like

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

[ale_spruce34 · Accepted solution]

Hi sorry we can close this. I figured it out.