Forum Discussion

Prabha45's avatar
Prabha45
Icon for Helper III rankHelper III
3 years ago

DAX - Selected value

Hi I wrote a measure where if is January is selected measure shows 1, february 2, so on till december. Measure = switch(selectedvalue                               (dim_table[month_name]),       ...
"DAX"
@Dax help
Advance DAX
Urgent Help with DAX
Prabha45's avatar
Prabha45
Icon for Helper III rankHelper III
3 years ago

Thanks that worked. I need the measure to be in integer format, but it is in Text format. I used convert to change it to integer then the output changed to 123.

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Prabha45 

Cannot have an integer with delimiter. What exactly are you trying to achieve?

  • Prabha45's avatar
    Prabha45
    Icon for Helper III rankHelper III
    3 years ago

    I need to trigger a function app with the filters selected in Power BI as input for the function app. It has month parameter which accepts inputs as 1 or 1,2 or 1,2,3. If I use the above measure( text format) it takes the values as "1,2,3". So, I converted it to integer then it took input as 123. 

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      3 years ago

      Prabha45 

      So with CONVERT you got your desired outcome? Or you still need further support? If so please clarify further perhaps with some examples and/or screenshots. 

      • Prabha45's avatar
        Prabha45
        Icon for Helper III rankHelper III
        3 years ago

        No. If I use convert, the output of the measure changes to 123. With 123 as input, I can't trigger the function app.
        If I don't use convert, the measure output is 1,2,3. when I pass this as input it takes as "1,2,3".