Forum Discussion

dana1's avatar
dana1
Frequent Visitor
8 years ago
Solved

Help with Measure

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?

 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI dana1

     

    Try replacing SELECTEDVALUE with VALUES

     

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

     

     

     

     

3 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    8 years ago

    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's avatar
      dana1
      Frequent Visitor
      8 years ago

      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's avatar
        Zubair_Muhammad
        Community Champion
        8 years ago

        HI dana1

         

        Try replacing SELECTEDVALUE with VALUES

         

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