Forum Discussion
Referencing Measures within Calculate
Hi amitchandak - I have figured the issue and the below does what i want to do
DPPM Number = AVERAGEX(FILTER('Date Table','Date Table'[Date] <= TODAY()) , SUM('Sub_Cust Reject'[Qty]) / SUM('Sub_Release Notes'[Qty]) * 1000000 + 0)Thanks for getting me on my way 🙂
Jackbaz99 , Th second measure is fine. DO you want to add filter to that ?
example
DPPM Number = CALCULATE(SUM('Sub_Cust Reject'[Qty]) / SUM('Sub_Release Notes'[Qty]),FILTER('Date Table','Date Table'[Date] <= TODAY())) * 1000000 + 0
amitchandak Hi, ive tried this but the dates still don't filter to the specific dates for some reason - i want to show ZEROS when the data is blank as the first measure does.
However this one still shows all of them. not filtered.amitchandak i am wondering if i need to use firstdateinperiod & lastdateinperiod
Jackbaz99 , you means
firstnonblankvalues and lastnonblankvalues
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak