Forum Discussion
Filter context not passed into calculated column
WilkerFRL94 , based on what I got. If you are trying to use filter/slicer value in a new calculated column that will not work. You can not use that in a new column.
You have to create a measure in such a case
Super UserWilkerFRL94 , based on what I got. If you are trying to use filter/slicer value in a new calculated column that will not work. You can not use that in a new column.
You have to create a measure in such a case
When i use a measure, i can get the correct values but that's all. Now i'm stuck with a measure, which still doesn't communicate with the other data:
1) if there's verified data, i don't need the measure - and that's why it was in a if statement in first place - so it ignores the prospected data from A and;
2) get me the average values for displayed x-axis.
I do believe i can create another measure to get average of measure and verified but it will allow the user to overlap prospected and verified if the date selected is older than verified data - and that occurs on a daily basis.
EDIT: oh, i see, i needed to change my verified field to a measure and not calculated column, now i can set both measures into an if statement! It works, thank you very much!