Forum Discussion
ngadiez
9 years agoHelper II
Measure value is not right
I have a table with 2 columns [Duration] and [Duration within] both have value 1,2,3,4. I also have a measure [Durations(Measure)] which get the selection from user. Durations(Measure) = IF(HASO...
ngadiez
9 years agoHelper II
No, it didn't work.
LaurentCouartou
9 years agoSolution Supplier
My guess is, your measure returns 1 because HASONEVALUE('Duration'[Duration]) returns false in your settings.
To help you further, we will need more details about your model.
Edit: Removed some misleading parts in my post.
- Vvelarde9 years agoCommunity Champion
A measure couldn't be use as part of a creation of a Column.
The columns not dinamically change of value. the measure working in the context when was called.
- ngadiez9 years agoHelper II
Is there any other way to do this?
One thing is to use the parameter and filter the data from queries.
However, I don't want this because it takes too long to load all the data when I change the parameters.
- ngadiez9 years agoHelper II
What I want to achieve is to compare the measure with the other column.