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.
Hi Selva-Salimi
thank you for your quick reply.
The month and year isn't fixed. I have a between-slicer where I select the year-frame I'd like to see.
The value has to be variable and must come from the first month of the earliest year selected.
Solution Sageok, then you can rewrite as follows:
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 this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
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.
- Selva-Salimi
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.
Thank you very much! That did the job. 🙂