Forum Discussion

michael_knight's avatar
michael_knight
Post Prodigy
5 years ago
Solved

Measure Formula changes depending on Slicer option

Hi,   I'm trying to create a measure which will change the formula depending on who is selected on the Slicer   We have multiple agents that get a different % of the Margin. In the example below ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Create a new table that will store margin values for each agent.




    Check and de-activate the relation between Agents and margin.



    Create new measure 

     

    New Margin % = (AVERAGE(margin[margin]))/100 * [Margin Measure]

     

    Now if you don't select any agent then it will select average margin.

    Now create a new slicer from Agent from the margin table.
    Output for John : 



    Output for Tom :


    Thank you.

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a new table that will store margin values for each agent.




Check and de-activate the relation between Agents and margin.



Create new measure 

 

New Margin % = (AVERAGE(margin[margin]))/100 * [Margin Measure]

 

Now if you don't select any agent then it will select average margin.

Now create a new slicer from Agent from the margin table.
Output for John : 



Output for Tom :


Thank you.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.




 

 

 

  • michael_knight's avatar
    michael_knight
    Post Prodigy
    5 years ago

    Thank you Anonymous