Forum Discussion

Jackbaz99's avatar
Jackbaz99
Helper I
4 years ago
Solved

Referencing Measures within Calculate

Hi, ihave created the follwoing code below to show zeros on a graph where the DATA doesnt exist, see below:     Concessions Raised = SUMX(FILTER('Date Table','Date Table'[Date] <= TODAY()),CALCUL...
Need Help
Show and Tell
  • Jackbaz99's avatar
    Jackbaz99
    4 years ago

    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's avatar
Jackbaz99
Helper I
4 years ago

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 🙂