Forum Discussion

ngadiez's avatar
ngadiez
Icon for Helper II rankHelper II
9 years ago

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...
Need Help
LaurentCouartou's avatar
LaurentCouartou
Icon for Solution Supplier rankSolution Supplier
9 years ago

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.

 

 

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

ngadiez

 

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.

 

 

  • ngadiez's avatar
    ngadiez
    Icon for Helper II rankHelper II
    9 years ago

    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.