Help with Measure

[dana1]

hello,

i have a table (CALL CENTER)  that contain 4 measure's (and ather columns, but thay are not relevent to my QA)

every measure calculate different percent-

1. X= improve avg wait time by 10%

2. Y= improve avg wait time by 2%

3. Z= improve avg wait time by 5%

4. W= conservation avg wait time.

and i have Another table that contain dates (DIM_DATE)

I need to create a report with hierarchySlicer by month, and when the users choose in the slicer september they will get the measure X , and when they choose in the slicer may they will get the measure Y, and when the users choose in the slicer july they will get the measure Z, Otherwise thay will get measure  W.

 i can't find a measure that will give me what i need.. 

any Suggestions?

[Zubair_Muhammad]

Hi @dana1

Try this MEASURE

Measure =
IF (
    SELECTEDVALUE ( DIM_Date[Month] ) = "September",
    [X],
    IF (
        SELECTEDVALUE ( DIM_Date[Month] ) = "May",
        [Y],
        IF ( SELECTEDVALUE ( DIM_Date[Month] ) = "July", [Z], [W] )
    )
)

[dana1]

hi @Zubair_Muhammad

First of all, thanks for the help!

I'm trying to do the measure, but when i do SELECTEDVALUE i cant choose a column ( DIM_date[month] ) ,

i can only choose a measure..

any Suggestions?

[Zubair_Muhammad · Accepted solution]

HI @dana1

Try replacing SELECTEDVALUE with VALUES

Then Select a single MONTH from DIM_date[month] slicer lets say "May"