Forum Discussion
Divide one value by reference value in a matrix (trend calculation)
would you try this solution:
var min_date= calculate(min(date), allselected(table))
var ref = CALCULATE(max(X), filter(ALLSELECTED(table), [date] = min_date)
return
divide ( selectedvalue( X) , ref)
** X is the column that contain tehse values **
if still not working, please provide some details about your tables, model and relationships.
Unfortunately, it is not working. I put only the ref variable in a measure and this is the result:
The result should be everywhere 1.834, if this dax expression works.
Solution Sagewould you try this solution:
var min_date= calculate(min(date), allselected(table))
var ref = CALCULATE(max(X), filter(ALLSELECTED(table), [date] = min_date)
return
divide ( selectedvalue( X) , ref)
** X is the column that contain tehse values **
if still not working, please provide some details about your tables, model and relationships.
Thank you very much! That did the job. 🙂