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.

Anonymous's avatar
Anonymous
Not applicable
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.

  • ValentinB's avatar
    ValentinB
    Frequent Visitor
    4 years ago

    Hello Anonymous ,

     

    Many thanks for your help, indeed it worked on my side as well. Was not fully aware of the "REMOVEFILTER" function but I am glad I've learned something new.

     

    Best wishes and Happy Holidays !