Need Alternative for 'Value' function

[Anonymous]

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

[Ashish_Mathur]

Hi,

How about nesting another IF() and VALUES()?  Does that work?

[Anonymous]

Hi, 

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

[SteveCampbell · Accepted solution]

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]
    )