Forum Discussion

ngadiez's avatar
ngadiez
Helper 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
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

ngadiez

 

 

As Vvelarde said, calculated column can’t dynamically change its value. So we have to need to use measure to do the calculation.

I create a test table named YearTable like below. It has no relationship with the Duration table.

 

 

We can create a measure with following formula.

Checking =
VAR DM = [Durations(Measure)]
RETURN
    IF (
        COUNTROWS ( FILTER ( YearTable, YearTable[Year] <= DM ) )
            > 0,
        "Yes",
        "No"
    )

 

Best Regards,
Herbert

  • ngadiez's avatar
    ngadiez
    Helper II
    9 years ago

    v-haibl-msft

     

    Thank you so much for the testing.

     

    I have tried it and it's working.

     

    However, I'm still trying how to incorporate this to mimic the same thing I want to achieve from calculated column. Because I want to do filtering based on the calculated column in DAX.

    Anyway, thank you so much for your help.

     

    • v-haibl-msft's avatar
      v-haibl-msft
      Microsoft Employee
      9 years ago

      ngadiez

       

      If it is woking, you can mark the right answer as solution, so that other users who have the same problem can find the solution quickly. :)

       

      Best Regards,
      Herbert