Forum Discussion

ValentinB's avatar
ValentinB
Frequent Visitor
4 years ago
Solved

Calculating DAX Measure (% Deviation) using Name Slicer Value

Good day all,   I am trying to wrap my head around an issue and can't seem to figure it out. Also tried searching different topics and either it didn't work or I didn't understand something in full...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ValentinB ,

     

    I have built a simple data sample:

    individual = SUM('Table'[Hour]) 
    company = CALCULATE(SUM('Table'[Hour]),REMOVEFILTERS('Table'[Name]))
    % Deviation = ( [individual]-[company]) / [company]

     

    Output:

     

     

    If you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

     

     

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

amitchandak's avatar
amitchandak
Super User
4 years ago

ValentinB , As you want selectedvalue as a benchmark, you need an independent table

 

So you need an independent company name table and use that in a measure to get that companies value and this should interact with visual

 

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

  • ValentinB's avatar
    ValentinB
    Frequent Visitor
    4 years ago

    Hello amitchandak ,

     

    I have accepted as a solution Anonymous method since it worked but I will also check and try to implement your part as I am on a learning curve regarding PowerBi and every intel is a good chance to develop more skills and methods.

     

    Many thanks as well for your reply and wish you also Happy Holidays.