Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

TRICY - DAX Measure Error

Hi Experts   I cannot work out why the following correlation Coefficent measure are going wrong - All my other Correlation Coeffient Measure work just Fine the following one the sample file - It no...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi, Anonymous 

I just modify the dax here in your measure:

This can resovle the issue , but it put in the visual it will return null due to the [Correlation Coefficent 7] returns null in this visual , you need to check this measures's logic when the filter context is put in this visual.

 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Aniya the measure errors when you add the measure to a standard table based on the date coming from BIODIESEL table

 

this is my final measure

FAME0 90-Day Volatility STDev = CALCULATE([RME-FAME0 Spread/Soybean Oil 90-Day Rolling 2], Window(94,ABS,0,REL, ALLSELECTED('DimDate'[Date]) , ORDERBY('DimDate'[Date],asc)))