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

Does the following work?

 

DurationfrMeasureIndex = CALCULATE( [Durations(Measure)]*12 )
  • ngadiez's avatar
    ngadiez
    Icon for Helper II rankHelper II
    9 years ago

    No, it didn't work.

     

    • 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.