Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

% Diff by Category

Hello, I am a novice at DAX and am looking for help on create a percent diff measure based on category.   Here's the raw data    System RunTime A 5 B 7   Here's what I am like ...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    First, Transform data>>Transform>>Transpose>>use first row as headers

    Then create a measure.

    %diff = SELECTEDVALUE('Table'[A])/SELECTEDVALUE('Table'[B])

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

     

     

    Best Regards

    Community Support Team _ Polly

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

First, Transform data>>Transform>>Transpose>>use first row as headers

Then create a measure.

%diff = SELECTEDVALUE('Table'[A])/SELECTEDVALUE('Table'[B])

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

 

 

Best Regards

Community Support Team _ Polly