Forum Discussion
Using value from measure in calculated column
Hi,
I have simple table with integer data, and show them as slicer selection, this is how it looks:
I have measure to determine selected value:
SelectedMinutesDelivery = SELECTEDVALUE(DeliveryMinutes[Column 1])
This shows correct data in table, but I wish to use selected value inside calculated column. Unfortunately I get blank result. Calculated Column:
CC_TEST = 2 * [SelectedMinutesDelivery]Result:
is there any chance to use it like this?
My goal is to create calculated column with datediff from two dates, check if difference is smaller or higher than selected value - based on that, I will return 0 or 1.
Hi piotrkopti ,
In your senario,measure would be a better choice than calculated column.
You could create a measure instead of calculated column.
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
Hi piotrkopti
A calculated column doesn't accept SELECTEDVALUE, use VALUE instead.
I would recommend to use measures to attend your objectif.
Hi piotrkopti ,
In your senario,measure would be a better choice than calculated column.
You could create a measure instead of calculated column.
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
