Measure Calculate Based Off Expression

[DataSciWannabe]

Hello,

I was hoping to get help writing a formula that would calculate based off the results of another expresion.

The data looks like the below except 2MM+ rows

Name	Date	Sales	Qty
a	12/1/2018	300	10
b	12/1/2018
c	12/1/2018	200	12
d	12/1/2018	500	17
a	1/1/2019	100	5
b	1/1/2019	600	20
c	1/1/2019	500	14
d	1/1/2019	900	25

I have a measure that calculates the price (Sales/Qty) and then one that calculates the change in price based off of two slicers for a beginning and end date. If there is no data in either the beginning or the end month (see the b name 12/1/2018), there is no ability to return a price change, so it is marked as a blank.

I would like to be able to return the total of sales from the date 

I have the measure below which calculates the sales total for values being captures, I want to adjust it for an additional filter where the value of the Blank Measure = 1, but nothing I try seems to be working

Sales Measure

CALCULATE([Sales],DATESBETWEEN('Calendar'[Date],VALUES(Beg_Slicer[Beg. Date]),VALUES(End_Slicer[End Date])))

Blank Measure

sumx(values('data'[name]), if([Price_Chg] = "",1,0) )

thanks all

[Anonymous]

Do you have Date/Calendar table? If so, is it marked as a Date Table in data view?  DATESBETWEEN is a time-intelligence function that requires a Calendar table to work correctly. If you dont have one, can make on pretty easily. But that would be initial step here I feel to troubleshoot your problem.