Forum Discussion

chutli's avatar
chutli
Frequent Visitor
5 years ago
Solved

Use parameters to create conditional columns

When I first created 3 Parameter. Service Level for A class I set up at 0.97, and B class at 0.95 and Class at 0.93. 

Then I created a calculated coloumn call "Service Level" based on the parameter user input. (Pic 1 & 2)

But the Parameter is not working. As you can see in Pic 3, i change the parameter on the slicer, but in Pic 2 the value still stay the same... 

 

Where did i do wrong? Help please!

 

orking. 

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey chutli ,

     

    that was a little trick, but try the following measure. I guess you have to adapt it to your tables:

    ServiceLevel = 
VAR vClassA = SELECTEDVALUE('Input_Service Level - A'[A Value], 1) -- Name of your Slicer table and column
VAR vClassB = SELECTEDVALUE('Input_Service Level - B'[B Value], 1)
VAR vClassC = SELECTEDVALUE('Input_Service Level - C'[C Value], 1)
VAR vAverage =
    AVERAGEX(
        Data_Master,
        VAR vRowClass = Data_Master[ABC_Class_Cost]
        RETURN
            SWITCH(
                vRowClass,
                "A", vClassA,
                "B", vClassB,
                "C", vClassC
            ) * 1
    )
RETURN
    vAverage

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

5 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey chutli ,

     

    a calculated column is always static. After the file is loaded the values are not gonna change anymore.

    So you have to solve that with a measure.

     

    If you help me to understand a little better how the result should look like I can also help you.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • chutli's avatar
      chutli
      Frequent Visitor
      5 years ago

      Hello selimovd , Colomn C is what I am trying to do. Does it make sense? Thank you

       

      • selimovd's avatar
        selimovd
        Most Valuable Professional
        5 years ago

        Hey chutli ,

         

        that was a little trick, but try the following measure. I guess you have to adapt it to your tables:

        ServiceLevel = 
VAR vClassA = SELECTEDVALUE('Input_Service Level - A'[A Value], 1) -- Name of your Slicer table and column
VAR vClassB = SELECTEDVALUE('Input_Service Level - B'[B Value], 1)
VAR vClassC = SELECTEDVALUE('Input_Service Level - C'[C Value], 1)
VAR vAverage =
    AVERAGEX(
        Data_Master,
        VAR vRowClass = Data_Master[ABC_Class_Cost]
        RETURN
            SWITCH(
                vRowClass,
                "A", vClassA,
                "B", vClassB,
                "C", vClassC
            ) * 1
    )
RETURN
    vAverage

         

        If you need any help please let me know.
        If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
         
        Best regards
        Denis