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
ngadiez's avatar
ngadiez
Icon for Helper II rankHelper II
9 years ago

I have found the problem.

 

Even though, the measure shows the correct number when displayed as a card. 

However, when I pass the measure to calculated column formula, it is assumed to be false.

Why is it so?

Is there any other way so I can pass this to calculated column.

 

  • LaurentCouartou's avatar
    LaurentCouartou
    Icon for Solution Supplier rankSolution Supplier
    9 years ago

    My guess:

    Your measure works in a card, because in your report, you directly (or indirectly) apply a filter to your Duration table and HASONEVALUE(Duration[Duration]) returns true.

     

    When evaluated in your calculated column, however, HASONEVALUE(Duration[Duration]) returns false, because the Duration table is not filtered, and your measure returns 1.

     

    Can you provide a screenshot of your diagramm view, so we can see how your tables are related?