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 1...
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"

     

     

     

     

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"