Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need Alternative for 'Value' function

Hi Team, 

I am facing an issue by using 'Values' as function in one my Query.

My Query: (Measure)

Year-Month = IF(values(Process_level) ="K10 Invoiced",IF(Month(TODAY())>3 ,(Month(TODAY())-3)*[Targets],(Month(TODAY())+9)*[Targets]
),[Targets])

 

Here "Targets" is a measure created. 

 

The problem I face is, as I use 'Values' I couldnt select multiple 'Process_Level' when I add this measure to my visual. I would like to know if any other funcation can be used as an alternative to "Values" or is there a way to handle this ?

 

Kindly help me to fix the same. Thanks in advance

 

Need Help
  • SteveCampbell's avatar
    SteveCampbell
    7 years ago

    Just to fully understand, can I confirm a few things -

    I am assuming " Process_level " is the name of a colmn? so it would be something like, Table1[Process_level] ?

    Are you adding to this to a table of visual, then [Process_level] this being used in a slicer?

     

    The problem is that values returns a table, a distinct list of all values. So if you have selected multiple, you are asking if a table equals the string value of "K10 Invoiced". SELECTEDVALUE could do the trick, and I would use a variable:

     

    Year-Month =
VAR _Process_level =SELECTEDVALUE ( [Process_level] )

    RETURN

        IF (
        _Process_level = "K10 Invoiced",
        IF (
            MONTH ( TODAY () ) > 3,
            ( MONTH ( TODAY () ) - 3 )
                * [Targets],
            ( MONTH ( TODAY () ) + 9 )
                * [Targets]
        ),
        [Targets]
    ) 

     

3 Replies

  • SteveCampbell's avatar
    SteveCampbell
    Memorable Member
    7 years ago

    Just to fully understand, can I confirm a few things -

    I am assuming " Process_level " is the name of a colmn? so it would be something like, Table1[Process_level] ?

    Are you adding to this to a table of visual, then [Process_level] this being used in a slicer?

     

    The problem is that values returns a table, a distinct list of all values. So if you have selected multiple, you are asking if a table equals the string value of "K10 Invoiced". SELECTEDVALUE could do the trick, and I would use a variable:

     

    Year-Month =
VAR _Process_level =SELECTEDVALUE ( [Process_level] )

    RETURN

        IF (
        _Process_level = "K10 Invoiced",
        IF (
            MONTH ( TODAY () ) > 3,
            ( MONTH ( TODAY () ) - 3 )
                * [Targets],
            ( MONTH ( TODAY () ) + 9 )
                * [Targets]
        ),
        [Targets]
    ) 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, 

      If 'Value' is used then multiple input cant be given as input. Instead 'FIRSTNONBLANK' can be an option